sql server dts: Complex format excel file to SQL Server -- sql server dts

Complex format excel file to SQL Server

Bob
11/7/2005 2:16:05 PM

sql server dts:

Hi
I have a complete format excel file which needs to be mapped to a Sql server
2000 table. I am looking different options currently available. It looks as
if DTS does not have enough functionality. What it basically offers is direct
mapping to table. I would like to split a cell into multiple rows if there
are more than one entry in each cell.

Re: Complex format excel file to SQL Server

Allan Mitchell
11/7/2005 10:38:15 PM

Then can you not adapt this?

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.