Informatica Connect to Excel workbook
 

READER_1_1_1 DBG_21438 Reader: Source is [Romania:Romania], user [PMNullUser]
I'll try to connect to an excel workbook with different country sheets
containing data, which I want to load into our DWH.
Now I'm getting the following error :

READER_1_1_1 Fri Dec 03 09:29:24 2004
READER_1_1_1 RR_4036 Error connecting to database [ [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified Database
driver error... Function Name : Connect Database driver error... Function
Name : Connect Database Error: Failed to connect to database using user
[PMNullUser] and connection string [Romania:Romania].].
READER_1_1_1 Fri Dec 03 09:29:24 2004
READER_1_1_1 BLKR_16001 Error connecting to database...
MASTER PETL_24020

Any help possible or do I have to export all sheets to single .csv files ?

Thanxxx

Michael