Importing Text File with Strange Delimiter

[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

 

[Jerry Whittle]

Mabye open up the text file in something like Word and find/replace the
double set of quotations marks with a single set.

If this is a file that you get from another system frequently, talk to
people who own that system. Maybe they can fix the output into something that
you can use.

 

[Jason]

That was a simple solution. Thank you very much! I actually went one step
further and removed all of the quotation markes because they were not
consistent across every field, causing Acess to miscalculate the field
lengths. The data imported perfectly.

Thanks again,
Jason

 

[Jack Cannon]

A note of caution.

Removal of all quote marks could cause a problem if a comma is contained
within a data field.

If that potential exists then you can still do the same by doing a
find/replace operation to replace the comma with something hardly ever used.
I like the vertical bar character instead of the comma.

Find "",""
Replace |

You can then designate | as the delimiter when you import.

Jack Cannon

 

[Jason]

Fortunately, I did not run into that problem this time. However, I
appreciate your advice and will keep it in mind for future references.

Thanks!
Jason