Hi. I am very new to VBA and the task in hand is a tough one to start with. Basically I have requirement of code I can run using Active X in DTS to load data that sits in excel files in a certain folder location into an sql server 2000 table. All the files will be of the same format and will be on the first sheet. I know I need a connection to the sql server database, a connection string to Excel Application, something to identify what table the data is to go in, an array and loop to hold the file names and load one file at a time. However I just do not know how to put it all together. I am in desperate need of this code so any help would be very appreciated.
Baz_Singh 0 Newbie Poster
AndreRet 526 Senior Poster
This is something I did for another user on Daniweb a while ago.
vb5prgrmr 143 Posting Virtuoso
Have a look at http://www.connectionstrings.com and use your friends (yahoo, google, ask, answers, bing) to search for vb6 ado tutorial...
Good Luck
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.