how to import a text file having "|" delimiters into access

  • Thread starter Thread starter dhiman2002
  • Start date Start date
D

dhiman2002

Please Help..
I need to import a text file having "|" (pipe separators) inti access
database.
Example :
Q29290006|000026173|046|
 
If you do not use an Import Specification in the TransferText action, ACCESS
will assume that the delimiter is a comma. If there is no comma in the line
of data in the text file, the entire line will be put into a single field.

You can create an Import Specification by beginning the import process
manually (File | Get External Data . . . | Import). When you've set all the
settings (delimiter, fields, etc.), on the last screen before you actually
do the import, click the Advanced button at bottom left of window. Then save
all the settings as a Specification (give it a name). You then can cancel
the import.

Use that specification name in the Specification argument of the
TransferText macro action.
 

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 Text file with Pipe Delimited - 2007 4
Import from notepad Pipe delimited text document 1
Importing Data with | as the delimiter in Access 2007 6
Import Trailing Spaces 8
Importing Text Files Into Access 1
Importing Text file with Strange Delimiter 1
Text import not WYSIWYG 1
Import Using Pipe as Delimiter 4

Back
Top