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
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