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.