|
Posted by nate.vu on 05/11/06 12:52
Hi Inna,
Perhaps this article will be of help:
http://www.devx.com/getHelpOn/10MinuteSolution/18088
The article at the link above shows how to import Excel data into SQL
Server from an indeterminate number of Excel workbooks.
If the # of Excel files you have is small, you can do the following in
the DTS Designer:
1) Drag 1 Excel connection object per file into the DTS "canvas" (the
main area of the DTS Designer) and define the connections as
appropriate
2) Drag a connection object for your SQL Server and define it as
appropriate. One thing to note is that you should set the DB to connect
to the same as the DB you want to import the data into
3) Define a "Transform Data Task" (see your Tasks menu in the DTS
Designer) between each Excel connection and the SQL Server connection.
4) A line will appear between each Excel connection and the SQL Server
connection. Right click on each line and select "Properties" from the
menu that appears. Alter the properties of the task (e.g. column
mappings) as appropriate.
5) Execute the task
Hope that helps a bit.
Navigation:
[Reply to this message]
|