Text Transfer Error Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Post the full information that you're using for the macro's arguments,
including filename argument, etc.

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

Wilf Wright said:
I am trying to import a comma delimited text file into an existing Access
Click to expand...
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.
 
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
 
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>

Wilf Wright said:
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
Click to expand...
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
Click to expand...
01 Import Specification, Barcode data, d:\Inventory01, Yes.
 
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
 
You're welcome!

--

Ken Snell
<MS ACCESS MVP>

Wilf Wright said:
Ken,

Many thanks for your help and a successful solution to the problem from
Click to expand...
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.
 
Back
Top