Connection error to excel as a data source

Asked By 0 points N/A Posted on -
qa-featured

 

Hi,

I am in trouble using Excel while I was trying to connect to excel as a data source and suddenly an error message appeared. I can’t understand to resolve this matter. The error message appeared as followed. I really need your help to fix this issue.

Thanks.

 

 

 

An error was encountered while evaluating rule Open Connection,in part Root.MyDbConnection

ERROR [IM002] [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified

 

SHARE
Answered By 0 points N/A #175705

Connection error to excel as a data source

qa-featured

Hi Richard,

                This error usually comes up when the application being imported and the file being exported are not written in the same database language.  Make sure that both are written in Access or SQL. This is an incorrect coding error that is having problems with the connection. You can create a DSN on your computer. However, you can check the system type and install the proper DSN on your computer (32 bit or 64 bit).

Related Questions