import delimited .txt files

G

ganderson

How do i import a delimited .txt file and use the pipe
character "|" as the delimiter?.
 
B

Brian

Use the Import Wizard, choose delimited, select "Other" as the delimiter,
then select the pipe character, which is the key above the <Enter> key
(shift required).
If you run the import through a macro you will want to go into the advanced
option of the wizard, save the specification, and then use that
specification when running the macro.
 

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

Pulling in .txt file via macro - NEED HELP 3
Export report to txt 2
Office365 Family + TXT or MX Domain 0
Auto Open Macro of external .txt file based on cell reference 1
Text to Rows 0
Import Using Pipe as Delimiter 4
Importing Data with | as the delimiter in Access 2007 3
Import Text file with Pipe Delimited - 2007 4

Top