<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV>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?</DIV>
<DIV> </DIV>
<DIV>If the wizard works ok, then it is a problem with your
code.<BR><BR>>>> paul.hartland@fsmail.net 01/30/03 09:49AM
>>><BR>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........<BR><BR><BR>From: "Nils R. Lenz"
<nilslenz@3oaks.com><BR>Date: Thu 30/Jan/2003 15:42 GMT<BR>To: "Access D
List Post E-Mail" <accessd@databaseadvisors.com><BR>Subject: [AccessD]
Importing dbf files<BR><BR>Has anyone had any luck importing dbf files? I
am using the following<BR>command to import: DoCmd.TransferDatabase acImport,
"dBase IV", _<BR> InputDir, acTable, txtFile, Import.
And I receiving the error that Jet<BR>could not find the object that I
selected. This was selected using the open<BR>file form that I took from
one Ken Getz’s books.<BR><BR>TxtFile is the dbf file that I trying to import and
Import is the table that<BR>I am trying to import to within Access.<BR><BR>Also,
if I type in DBase 5, I receive this error: dBase 5 isn’t an
installed<BR>database type or doesn’t support the operation you chose.<BR><BR>I
am using Access 2000 with everything installed except for the
Office<BR>Assistant.<BR><BR>Thank you,<BR><BR><BR><BR>Nils R Lenz<BR>B & N
Lenz Enterprises<BR>Telephone/Fax
813-782-9491<BR><BR><BR><BR><BR>__________________________________________________________________________<BR>Freeserve
AnyTime - Go online whenever you want for just £6.99 a month for<BR>your first 3
months, that's HALF PRICE! And then it's just £13.99 a month<BR>after
that.<BR><BR>For more information visit <A
href="http://www.freeserve.com/time/">http://www.freeserve.com/time/</A> or call
free on <BR>0800 970
8890<BR><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR>AccessD@databaseadvisors.com<BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></DIV></BODY></HTML>