This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / HELP: I tried to import some records to SQL SERVER by using DTS, and always missing some records in two fields...for example: in "lotnum" field(as verchar), at first 100 records like "456789032", and then 100 records like "34343RDF" or "34_65", the most records in last 100 always missed. anybody knows??? and when I find the missing records in that .xls file , copy to a new excell file and then import well...:(....why........?
-shinning(dudu);
2003-5-13
{324}
(#1186665@0)
-
你的SQL SERVER 做DTS的时候多少RECORD commit 一次？一般是1000，是不是你设了100 然后最后的数据有些FIELD有错误？
-argc(argc);
2003-5-14
(#1187594@0)
-
thanks, I didn't set up this records commit, I think it's default..I want to import at lease 10000 records at one time, the field is ok, i checked it, only digital number or chars. I set up that field as "VARCHAR"...I have 76000 records, and I lost almost half records in one field......:(((
-shinning(dudu);
2003-5-14
{226}
(#1188180@0)
-
Try "nvarchar" or let sql create table for you, then you can change the table name and datatype after the import.
-greenspring(春天);
2003-5-15
(#1189839@0)