[AccessD] Importing dbf files

Just an initial thought, does txtFile return the full path, filename and file extension.........?, if not, try adding the .dbf to the end of txtFile........


From: "Nils R. Lenz" <nilslenz at 3oaks.com>
Date: Thu 30/Jan/2003 15:42 GMT
To: "Access D List Post E-Mail" <accessd at databaseadvisors.com>
Subject: [AccessD] Importing dbf files

Has anyone had any luck importing dbf files?  I am using the following
command to import: DoCmd.TransferDatabase acImport, "dBase IV", _
    InputDir, acTable, txtFile, Import.  And I receiving the error that Jet
could not find the object that I selected.  This was selected using the open
file form that I took from one Ken Getz’s books.

TxtFile is the dbf file that I trying to import and Import is the table that
I am trying to import to within Access.

Also, if I type in DBase 5, I receive this error: dBase 5 isn’t an installed
database type or doesn’t support the operation you chose.

I am using Access 2000 with everything installed except for the Office
Assistant.

Thank you,



Nils R Lenz
B & N Lenz Enterprises
Telephone/Fax 813-782-9491




__________________________________________________________________________
Freeserve AnyTime - Go online whenever you want for just £6.99 a month for
your first 3 months, that's HALF PRICE! And then it's just £13.99 a month
after that.

For more information visit http://www.freeserve.com/time/ or call free on 
0800 970 8890