August 29, 2002 at 10:39 am
Hi,
I need help in creating a VB.exe using SQL-DMO to bulk insert delimited files (from a client that is in a different location than the server) into their respective tables on SQL Server 6.5. Right now I am insert one record at a time, which is fine for records that total less than 50 but as the numbers increase (it can be up a few thousands of records) the longer it takes.
What I want to be able to do is use the bulk insert statement to append records to the tables on the server. Can somebody please help me or point me in the right direction as to how I can achieve this.
I'm using VB6 with SP5 on windows 2000 Prof and SQL Server 6.5
Thanks in advance.
August 29, 2002 at 1:22 pm
Is there a bulk insert in 6.5? Not very familiar with DMO on 6.5 either, probably a few differences! What data format are you importing from? Can you use BCP?
Andy
August 29, 2002 at 1:27 pm
I'm using tab delimited files. I can connect to it 6.5 using SQL-DMO in VB6 but I don't know what else can I do.
insha.
August 29, 2002 at 1:52 pm
BCP is the fastest way. I'd start by getting that to work from a command prompt, once you have that, see if there is native support for it in DMO or if you will have to shell bcp.exe.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply