Freelance Projects
| Dts Activex |
| Monday, 29 June 2009 22:45 | |||
|
Need 1 sql activex script task for DTS to
Import ALL excel files in a folder into sql Tables.
Folder C:A
sheet1 go to table1
sheet2 go to table2
Columns to import
Sheet1 A to Z
Rows to import= import all records where colum A had data.
fields name for sql table can just be a to z as in excel file.
do the same for sheet2.
http://www.devx.com/getHelpOn/10MinuteSolution/18088/1954
|
