[AccessD] Importing dbf files

I use A97 and import dbf files all the time.  I don't use code, it is a manual process using the Import wizard.  Have you tried that to see if you still get the error message?

If the wizard works ok, then it is a problem with your code.

>>> paul.hartland at fsmail.net 01/30/03 09:49AM >>>
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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030131/ed28771b/attachment-0002.html>