Text Transfer Error Problem

[Guest]

I am trying to import a comma delimited text file into an existing Access table using the Macro "Transfer Text" action but I get an error message telling me "The Microsoft Jet database engine cannot open the file ''." Importing the same text file works fine when using the "Get External Data" wizard. Can anyone advise me please on why I get the error message when using the macro as I have come to a complete impass.

 

[Ken Snell]

Post the full information that you're using for the macro's arguments,
including filename argument, etc.

--
- - - - - - - - - - - - - - - - -
Ken Snell
<MS ACCESS MVP>

I am trying to import a comma delimited text file into an existing Access

table using the Macro "Transfer Text" action but I get an error message
telling me "The Microsoft Jet database engine cannot open the file ''."
Importing the same text file works fine when using the "Get External Data"
wizard. Can anyone advise me please on why I get the error message when
using the macro as I have come to a complete impass.

 

[Guest]

Thanks Ken for taking an interest in my probelm. It is very good of you to spare the time

The arguments of the macro I am using are as follows
Transfer type: Import delimited, Specification Name: Inventory01 Import Specification, Table Name: Barcode data, File name: d:\Inventory01, Has Field Names: Yes

The arguments listed in the "Action Failed" message box are: 0, Inventory 01 Import Specification, Barcode data, d:\Inventory01, Yes

Hope this information assists you in diagnosing the reason for the error message

Wilf

 

[Ken Snell]

Your filename does not have a file extension at the end of it. Assuming that
it's a .txt file, change the file name argument to

d:\Inventory01.txt

--
- - - - - - - - - - - - - - - - -
Ken Snell
<MS ACCESS MVP>

Thanks Ken for taking an interest in my probelm. It is very good of you to spare the time.

The arguments of the macro I am using are as follows:
Transfer type: Import delimited, Specification Name: Inventory01 Import

Specification, Table Name: Barcode data, File name: d:\Inventory01, Has
Field Names: Yes.

The arguments listed in the "Action Failed" message box are: 0, Inventory

01 Import Specification, Barcode data, d:\Inventory01, Yes.

 

[Guest]

Ken

Many thanks for your help and a successful solution to the problem from myself and Containers of Hope (www.containersofhope.org,the aid charity I am writing Access databases for) . We can now use the barcode scanning facility for speeding up the production of the container shipping manifests. Thanks again for your time and excellent advice

Wil

 

[Ken Snell]

You're welcome!

--

Ken Snell
<MS ACCESS MVP>

Ken,

Many thanks for your help and a successful solution to the problem from

myself and Containers of Hope (www.containersofhope.org,the aid charity I am
writing Access databases for) . We can now use the barcode scanning facility
for speeding up the production of the container shipping manifests. Thanks
again for your time and excellent advice.