I'm attempting my first ever Excel OLEDB. I'm not sure exactly where the problem lies. I'm wondering if it is using JET vs ACE connection.
When I ran it through using Microsoft.Jet.OLEDB.4.0 I got it to go through but it could not find the file. I was wondering if that is because I'm on a new version and the Jet appears to be for older excel. In trying to change to the ACE connection I am running into problems of not conforming. Details below. Any ideas?
Could not execute code stage because exception thrown by code stage: Format of the initialization string does not conform to specification starting at index 130.
Hi Amlan, I could set the connection and open the connection with a few small tweaks. "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='................';Extended Properties='Excel 12.0 Xml;HDR=No'"
I can set connection, open connection, but then when trying to get collection I get a - "Could not execute code stage because exception thrown by code stage: Could not find installable ISAM." So maybe search of "installable ISAM"?? Hope that helps.
------------------------------ Jonathan Holstine Systems Accountant Interior Business Center America/Denver ------------------------------
HI Dave, Like this error I'm getting - "Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression."
I'm using the following sql statement: "Select F2 From [MCDR$] Where F6 >0"
F2 column is a general column. The F6 column values come in as custom. I've since tried formatting them to general, text, and number but the same error comes through with all of them. Any ideas?
Thanks! Jon
------------------------------ Jonathan Holstine Systems Accountant Interior Business Center America/Denver ------------------------------
Hi Rajath, Thanks for the suggestions. I tried both and getting the same error. Would this have anything to do with putting an IMEX into connection string. Or any other ideas?
Thanks, Jon
------------------------------ Jonathan Holstine Systems Accountant Interior Business Center America/Denver ------------------------------
I see when I go to evaluate expression it shows the 0 as a Text. Any other ideas of how to get that to a number (I'm guessing that is what these attempts were trying to do).
------------------------------ Jonathan Holstine Systems Accountant Interior Business Center America/Denver ------------------------------
I'm not sure. I'm working with an xls file but it appears from reading you need to change data source. Here is a link with a few options of fixing issue.