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.
--
Ken Snell
<MS ACCESS MVP>
<dhiman2002[ at ]yahoo.com> wrote in message
news:1152466453.328423.294800[ at ]p79g2000cwp.googlegroups.com...
[Quoted Text] > Please Help..
> I need to import a text file having "|" (pipe separators) inti access
> database.
> Example :
> Q29290006|000026173|046|
>
|