Complex format excel file to SQL Server

#1

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.

Thanks

#2

Then can you not adapt this?

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

Allan

"Bob" <Bob (AT) discussions (DOT) microsoft.com> wrote

Quote:

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.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Complex format excel file to SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Complex format excel file to SQL Server - 11-07-2005 , 04:16 PM

Re: Complex format excel file to SQL Server - 11-07-2005 , 04:38 PM