Importing Text file with Strange Delimiter

J

Jason

I have a text file and it appears that the fields are separated by the
following characters: "",""

So, if I chose to import as comma delmited it separates my fields correctly
but keeps the quotation marks in the fields and won't let me import giving me
the error that "system resource exceeded"

Also, if I chose to import as comma delmited with a quotation mark as a the
text qualifier, it imports everything into one field. Is there a way that I
can tell access to read the delimiter as "",""

Thanks,
Jason
 
K

Ken Snell \(MVP\)

Is the delimiter really "","" or is the "' supposed to represent that the
values are text values?

Post an example of the contents of the text file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top