sqlsql-serverexcelimportinsert-statement

How to retrieve the insert statements from an SQL Database that I imported from an Excel file

i recently used a MS excel database and imported it into an database but i want to get all the insert statements that the import made.

Is it possible? All i can see is the executed database in my object explorer but i want all the insert statements of the imported data??

OK let me try explain again :) i have thousands of rows of data in an excel spreadsheet, how do i convert the rows of data to a database. I'm asking like this now because i think i just messed up on the previous try:(

Solution

  • Export the table in sql format
    The Format of Output of .sql file is In the form

    Create Table Statements
    Insert each entry statement

    So Open that .sql file and copy all INSERT statement

    Hope this was your requirement