By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,476 Members | 889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,476 IT Pros & Developers. It's quick & easy.

Import Error Tables

P: n/a
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

Oct 12 '06 #1
Share this Question
Share on Google+
2 Replies


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

Oct 13 '06 #2

P: n/a
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..

pi********@hotmail.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.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

Oct 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.