I would like to write a DTS package to import a number of Excel files
from a network directory to a single SQL Server table.
Assumptions:
I am assuming that the coulmns are constant among the Excel files and
only the file content is different.

1. Is there a function to read a predefined network directory to obtain
a list of Excel files.
2. What is the best method to import the contents of the Excel files in
to a SQL Server database table.

Any insight will be greatly appreciated.


*** Sent via Developersdex http://www.developersdex.com ***

You can very easily adapt this

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Paul Backer" <paul_b_backer (AT) yahoo (DOT) com> wrote