Text Qualifier - Quote Marks

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?
 
V

Van T. Dinh

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?
 

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

Similar Threads

Quote Marks Question 2
Unparsable Record 1
How do I convert an Access text string with spaces into columns? 1
Double quotes within text cause unparsable record error 2
How do I change text qualifier from double quote? 1
setting text qualifier in Excel 1
How to stop Excel adding quotation marks when copying to notepad? 3
Part number surrounded by quotation text qualifier imports as a number not text 1

Top