[AccessD] SQL Server observed performance

Gustav Brock Gustav at cactus.dk
Tue Oct 31 11:57:48 CST 2006


Hi Rusty

Yes, or - if SQL Server 2005 - SSIS FastParse option:

http://weblogs.sqlteam.com/mladenp/archive/2006/05/26/9992.aspx 

/gustav

>>> rusty.hammond at cpiqpc.com 31-10-2006 18:37:00 >>>
John,

You might look at the BULK INSERT statement in SQL.  The import of the text
file is done by the server itself.  I would imagine you'll see an even
better performance boost for the import.

Rusty




More information about the AccessD mailing list