Informatica Connect to Excel workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel connection to ODBC database 10
troubles with dns-less connection to sql 0
ADO retrieval from close workbook-data type issue 2
ODBC Issue with Pivot Table 1
Import to the next blank row 2
ODBC Microsoft Access Driver Login Failed 1
Use named table in workbook as source for pivot tbl in other workb 1
2007 Pivot Tbl to Access Conversion Issues 6

Back
Top