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 2000 Forums  SQL Server Development (2000)  Record missing when loading data from Excel

Author  Topic  momoko Starting Member 1 Post Posted - 2005-09-29 : 01:35:17 Hi, I have to load data from Excel 2000 to MS SQL using ASP (vbscript). And I am facing some problem that some records are missing when the program has finish running with error message. 3 records are missing when I am loading a excel file with 450 rows, but no record is missing after I break down the excel file into a few smaller files (40 rows each). Can anybody explain this to me? and tell me how to solve the problem without breaking the excel file? Thank you. From, Momoko