How would you load 52,000 records from ascii file

[Dan01]

It takes approximately 15 minutes to manually load a 52,000 record file into and Access database using an import specification. Would SQL server load faster? Thanks, Dan.

 

[foxdev]

I'm not an Access user, but my guess is that there is a lot of "it depends". Are they (SQL Server and Access) both running on the same box? Are they both accessing the source file from the same location? Assuming "yes" to these two, then the last variable is: what method would you use to import the file: DTS, bulk insert, or bcp?

My guess is that SQL Server would be faster, because even though it does more work (transaction logging, for example), the SQL Server engine is probably a bit better tuned for this sort of grunt work.

But I think only time trials would reveal the correct answer for you in your situation. 15 minutes does seem like a really long time for only 52,000 records. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com