Post reply

Import data from Microsoft Excel to Microsoft SQL Server 2005

  • December 25, 2010 at 2:43 am

    #388503

    Hi, anyone know how to import data from Microsoft Excel to Microsoft SQL Server 2005? I need to import about thousand of data from Microsoft Excel to Microsoft SQL Server 2005. Currently the way I use to do this is write a Java program which read data from Microsoft Excel and insert into Microsoft SQL Server 2005, but seems I need to insert thousand of data from Microsoft Excel to Microsoft SQL Server 2005, so how can I know is it got some of the data no insert into database. So, anyone know what is the suitable and correct way to import data from Microsoft Excel to Microsoft SQL Server 2005 ? Anyone know how to trace and confirm whether all data insert completely into database? Thanks.

  • December 25, 2010 at 7:05 am

    #1266271

    In the upper right hand corner of the forum page .. input "import from Excel". Click "Go". In the page that is shown click in the forum and script blocks to remove the check marks. Click on once again on "Go" and you will receive a list of 7,808 entries. Scan them and read those that seem most appropriate to what you need to accomplish. If after that you have additional problems, post them to a new forum for further assistance.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • December 25, 2010 at 8:18 pm

    #1266294

    In SSMS, right-click on the database and select Tasks | Import Data. Set the source to be your excel file; set the destination to be a newly created table. Import, and view results. Transfer data into the permanent table, either with T-SQL, or by re-running the Import Data Wizard and setting to the permanent table. (You'll have more control by using the staging table / T-SQL, and this is the method that I would use.)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply