Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  Import data from Microsoft Excel to SQL Server

Author  Topic  cthesky Starting Member 1 Post Posted - 2010-12-25 : 04:19:33 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.