dbk
SSC Rookie
Points: 45
More actions
May 26, 2009 at 12:32 am
#999729
Try this
CON.Open "PROVIDER=sqloledb;DATA SOURCE=ip;DATABASE=databasenamel;USER ID=username;password=password"
Bala
Gosta Munktell
SSCertifiable
Points: 6004
May 27, 2009 at 2:48 am
#1000411
I would recommend that you save the Excelsheet(s) as tab separated textfiles and use bulkinsert instead.
/gosta
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply