- Posts: 271
- Thank you received: 22
22018 Access ODBC Miscrosoft Access Driver - Invalid Character
7 years 8 months ago #14171
by DeanCovey
I have gotten this error a couple of times. I am using MS-Access and writing a couple of queries to narrow down my data. i am using the one query as a reader in Advanced ETL. I review the data in the browse data function and then again by exporting to text file. Nothing jumps out.
Any thoughts?
Any thoughts?
Please Log in or Create an account to join the conversation.
7 years 8 months ago #14172
by DeanCovey
Replied by DeanCovey on topic 22018 Access ODBC Miscrosoft Access Driver - Invalid Character
Here's the text file if someone would like to review.
Please Log in or Create an account to join the conversation.
7 years 8 months ago #14173
by DeanCovey
Or not.
Replied by DeanCovey on topic 22018 Access ODBC Miscrosoft Access Driver - Invalid Character
DeanCovey wrote: Here's the text file if someone would like to review.
Or not.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
7 years 8 months ago #14174
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic 22018 Access ODBC Miscrosoft Access Driver - Invalid Character
Can you provide us with actual Access file please.
If it is too big delete all the tables except the one which is failing.
(zip it first)
If it is too big delete all the tables except the one which is failing.
(zip it first)
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
7 years 8 months ago #14175
by DeanCovey
Replied by DeanCovey on topic 22018 Access ODBC Miscrosoft Access Driver - Invalid Character
Really can't. The error is from a passthrough query that is opening a ODBC table.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
7 years 8 months ago #14176
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic 22018 Access ODBC Miscrosoft Access Driver - Invalid Character
What is passthrough query?
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.