22018 Access ODBC Miscrosoft Access Driver - Invalid Character

More
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?
Attachments:

Please Log in or Create an account to join the conversation.

More
7 years 8 months ago #14172 by DeanCovey
Here's the text file if someone would like to review.

Please Log in or Create an account to join the conversation.

More
7 years 8 months ago #14173 by DeanCovey

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.

More
7 years 8 months ago #14174 by Peter.Jonson
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)

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
7 years 8 months ago #14175 by DeanCovey
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.

More
7 years 8 months ago #14176 by Peter.Jonson
What is passthrough query?

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.