Load data using Excel file as source and target

I want to send the excel sheet as a source to another excel sheet as target.so i created a mapping with source excel sheet to target excel sheet correctly.
but i'm failing to enter the correct connection string in establishing relational connections for type ODBC .My ODBC data source is XL(Microsoft Excel Driver(*.xls)).
tell me what is the connection string for ODBC (Like oracle is the conn string for Oracle services)

sasha
Profile Answers by sasha Questions by sasha
Aug 10th, 2006
1
5978

Questions by sasha

Informatica

Answer

Showing Answers 1 - 1 of 1 Answers

Mohamed Ismath

Aug 14th, 2006

Save the source excel sheet as *.csv that is comma delimeted file and then you can import as flat file..
Now you are trying to import source and traget as ODBC and there by when you connect the traget or try to preview data .. you get connect string error..
Try the above it should work
Regards
Mohamed Ismath :-)