B
Ben
I am tring to write a module that will parse the data in excel files
contained in a directory and then push the data to a sql server table. I
have this created as a DTS package in SQL server, but since i need to use an
excel object and we do not want to install excel onto our severs, my only
other option is to do this.
How can this be done? I know with the import wizard you can specify the file
name but i need it to dynamically import all files from a directory and push
the record sets to a table.
thanks for any and all help!
Ben
contained in a directory and then push the data to a sql server table. I
have this created as a DTS package in SQL server, but since i need to use an
excel object and we do not want to install excel onto our severs, my only
other option is to do this.
How can this be done? I know with the import wizard you can specify the file
name but i need it to dynamically import all files from a directory and push
the record sets to a table.
thanks for any and all help!
Ben