thks for reply...all my excel files are stored in a folder at a particular location....I have VS.net 2005 installed...I can use C# or VB.net....plz let me know the steps to create a DTS package....will be thankful for ur help...
Pls let us know,
Your many excel files are stored at one location or different location?
Another thing, using DTS Package, you can import data from particular single excel file.. Stored at particular location on PC Where you are making / designing this DTS Package.
Cant you use some programming along with? If your many excel files are stored in particular folder, then you can make small utility, which takes folder's address/location and imports all the file to particular table.