My intention is to export data from a specific cell (eg. A3) in Excel spreadsheet to a column in a table in SQL Server. For Example: Cell B3 to Column1, Cell E4 to Column2, and so forth. My question is can it be accomplished using DTS? And if it can be done, where do I find the resources to perform the transformation?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export data from Excel to SQL 2K using DTS
- Thread starter Ynnx
- Start date
Similar threads
- Locked
- Question
