Automatically Import Excel files of different name to same table 1

[goldsmt]

I want to be able to read in multiple excel spreadsheets into a single table using DTS.

The excel spreadsheets will have the same format for each, their names will be somthing like

sales-28-06-04.xls
sales-29-06-04.xls
etc

I want to process all the xls files in a certain directory that start with sales*.xls but make sure I do not import the same file twice.

Regards

Tony Goldsmith

 

[JohnDTampaBay]

Here is an article on just that. Good luck!

http://www.sqldts.com/?246

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[goldsmt]

thanks John

That looks excellent