[AccessD] Importing dbf files

Hollis,Virginia HollisVJ at pgdp.usec.com
Thu Jan 30 14:32:01 CST 2003


I just imported the tables into Access, the ones that gave me the error
message, I opened in Excel & then brought them into Access.
 
Virginia
-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Thursday, January 30, 2003 2:05 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Importing dbf files


If I remember correctly, later versions of dBase files require the Borlund
Database Engine on the machine for the import/export to work.
 
Charlotte Foust
-----Original Message-----
From: Nils R. Lenz [mailto:nilslenz at 3oaks.com] 
Sent: Thursday, January 30, 2003 7: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/5c134fa4/attachment-0002.html>


More information about the AccessD mailing list