How do import data using | as a delimeter?

G

Guest

Not sure if you can use that character in an Import Specification but you
could always do a Find & Replace on the text file to convert them to commas.
 
P

Pat Hartman

File/Import - change the file type, select the file you want to import.
When the wizard opens, press the Advanced button to see the option to change
the delimiter. You should be able to type a character in the field if it is
not in the list.
 
G

Guest

This works perfectly. Thanks for your help!

Pat Hartman said:
File/Import - change the file type, select the file you want to import.
When the wizard opens, press the Advanced button to see the option to change
the delimiter. You should be able to type a character in the field if it is
not in the list.
Click to expand...
 

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

Import delimeter file into existing table? 15
Data, Text to Columns, has commas in the text, plus as a delimeter 2
csv delimeter 3
how to treat consecutive delimeter as one when importing data? 1
643 text files to be automativally imported to access 1
Save Excel file to CSV with quotation mark data delimeter? 2
Is it possible to import data from a e-mail? 1
How can I seperate Imported text with delimeter as part of the par 5

Top