Importing Text file with Strange Delimiter

  • Thread starter Thread starter Jason
  • Start date Start date
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
 
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.
 
Back
Top