Text Qualifier - Quote Marks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I import an extracted datafile for a project at work. It is tab delimited with double quotes as the text qualifier. My data imports fine, except that everthing has quote marks around it, as it appears in the raw data. Is there anyway I can import the data without the quotes, short of opening each huge file in Notepad and doing a find and replace?
 
Yes.

In the 2nd or the 3rd Dialog of Import steps, there is an "Advanced ..."
button which let you specify the Text delimiter. If you specify the
double-quote as Text delimiter, these double-quotes won't be included as
Field values.

HTH
Van T. Dinh
MVP (Access)



Imarcus said:
I import an extracted datafile for a project at work. It is tab delimited
Click to expand...
with double quotes as the text qualifier. My data imports fine, except that
everthing has quote marks around it, as it appears in the raw data. Is
there anyway I can import the data without the quotes, short of opening each
huge file in Notepad and doing a find and replace?
 
Back
Top