| || |
I try to establish the connection, but the connection is not established.
am getting the following error:
"Datasource name not found and no default driver specified"
can anybody help me out how to fix this? or let me know where am missing...
ConnectionString ="DSN=Excel;DBQ="&AppPath &"\81.xls;DefaultDir=" &AppPath &";DriverId=790;FIL=excel 8.0;MaxBufferSize=2048;PageTimeout=5;"
SQL = "SELECT `'81$'`.IdgenNo, `'81$'`.QueryforAccSummary, `'81$'`.AccountName FROM `'81$'` `'81$'` WHERE `'81$'`.IdNo='Tsc1.a081'"
Ex_Recordset.Open SQL , Ex_Con
Re: Excel Connection
Your connection string is wrong, you need to either setup the DSN on your machine or change your connection string. Search the forum and you will get the connection string that you should be using...