[AccessD] Importing dbf files

Charlotte,

OK thanks,

Nils

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Hollis,Virginia
Sent: Thursday, January 30, 2003 3:32 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Importing dbf files

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/9498690a/attachment-0002.html>