PDA

View Full Version : Feeding data set into a sql stored proc using VBA



Lionheart
11-30-2010, 05:32 AM
Good morning

I have a string in a worksheet that I am looking to feed into a sql table directly using vba; i.e. not wanting to create a csv file and then batch uploading. The data set has 15 columns and will be of varying number of rows. Does anybody have any code suggestions for being able to do this, please?

Thx

LH

stanl
12-01-2010, 01:07 PM
You could make up your mind. Do you want to stream to a stored proc as the title suggests or to a table, as the text suggests?

If you are sure there will be no data validation issues, I see nothing wrong with just issuing a BULK INSERT. .02 Stan