There's a command line utility called bcp (stands for "bulk copy paste") that does just this. Just type bcp at the command line of a SQLServer machine for usage. ----- Original Message ----- From: Paul Johnston To: [EMAIL PROTECTED] Sent: Monday, January 12, 2004 5:38 PM Subject: [ cf-dev ] Bulk Insert Into SQL Server DB
Ok. I am building a system using CF to insert a large amount of data into a database (SQL Server 2k). Problem is that it's large amounts of data on a regular basis (think of it as an info gathering tool). The tool basically recieves a large regular amount of data, and needs to re-format and deposit into the database. Problem is that it takes up resources in CF that are quite unnecessary (I think). Is there anyway I can dump all the data into a text format of some sort and do a bulk insert of that data? Paul -------------------------- Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: +44 7866 573013 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
