[AccessD] Importing dbf files

Hollis,Virginia HollisVJ at pgdp.usec.com
Thu Jan 30 09:58:00 CST 2003


I had this problem when converting dBase to Access. I had to export the
table into Excel & then into Access - this worked.
-----Original Message-----
From: Nils R. Lenz [mailto:nilslenz at 3oaks.com]
Sent: Thursday, January 30, 2003 9:42 AM
To: Access D List Post E-Mail
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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030130/63b0455d/attachment-0002.html>


More information about the AccessD mailing list