Import Error Tables

[mattc66 via AccessMonster.com]

We import data from ASC files. At times the data contains " quotes in the
descrition resulting in Import Errors. What I would like to do is create some
sort of query that would show the data in question.

The Import error gives me the line# referance. I would like to display this
line back to the user doing the import.

Does anyone have any examples of how I may be able to handle this issue?

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via http://www.accessmonster.com

[pietlinden@hotmail.com]

Re: Import Error Tables

Did you create an import specification so that Access treats the quotes
as something other than a field delimiter?

[mattc66 via AccessMonster.com]

Re: Import Error Tables

Quotes are treated as fld delimiters ",". So if the user puts additional
quotes in the body of the data yet it doesn't contain the comma the import
fails to import the rest of the data for that record..

pietlinden@hotm ail.com wrote:

>Did you create an import specification so that Access treats the quotes
>as something other than a field delimiter?

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200610/1