I have tried unsuccessfully to open a .dbf file in Access 2003. I downloaded
the dbf file from a website. I open a blank new Access db, click on
File/Open, select dbase as my file type (I've tried dbase III, IV & V),
browse to the dbf file and select it and click on the Open button. I get the
following error msg:
"The MS Jet database engine could not find the object <<dbase
filename.dbf>>>. Make sure the object exists and that you spell its name and
the path name correctly."

I have the latest 4.0 jet engine service pack installed (4.0.8618.0).

Use File|Get External Data|Import...

On Wed, 21 Feb 2007 22:07:13 -0800, FrypanJack
<(E-Mail Removed)> wrote:

>I have tried unsuccessfully to open a .dbf file in Access 2003. I downloaded
>the dbf file from a website. I open a blank new Access db, click on
>File/Open, select dbase as my file type (I've tried dbase III, IV & V),
>browse to the dbf file and select it and click on the Open button. I get the
>following error msg:
>"The MS Jet database engine could not find the object <<dbase
>filename.dbf>>>. Make sure the object exists and that you spell its name and
>the path name correctly."
>
>I have the latest 4.0 jet engine service pack installed (4.0.8618.0).

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.

Hi.

> I have tried unsuccessfully to open a .dbf file in Access 2003.

Access 2003 will allow you to open this file by creating a linked table to
it in the current database -- if and only if the file name is no longer than
eight characters. However, linking to the table may not be what you want.
If you want a copy of the table to reside in the MDB file, then you must
import it, not "open" it.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"FrypanJack" <(E-Mail Removed)> wrote in message
news:E0F2A272-72B9-49D3-9506-(E-Mail Removed)...
>I have tried unsuccessfully to open a .dbf file in Access 2003. I
>downloaded
> the dbf file from a website. I open a blank new Access db, click on
> File/Open, select dbase as my file type (I've tried dbase III, IV & V),
> browse to the dbf file and select it and click on the Open button. I get
> the
> following error msg:
> "The MS Jet database engine could not find the object <<dbase
> filename.dbf>>>. Make sure the object exists and that you spell its name
> and
> the path name correctly."
>
> I have the latest 4.0 jet engine service pack installed (4.0.8618.0).

Thank you John. I actually did previously try the import and received the
same error msg. someone else advised that the dbf filename must be 8
characters or less and that resolved it.

"John Nurick" wrote:

> Use File|Get External Data|Import...
>
> On Wed, 21 Feb 2007 22:07:13 -0800, FrypanJack
> <(E-Mail Removed)> wrote:
>
> >I have tried unsuccessfully to open a .dbf file in Access 2003. I downloaded
> >the dbf file from a website. I open a blank new Access db, click on
> >File/Open, select dbase as my file type (I've tried dbase III, IV & V),
> >browse to the dbf file and select it and click on the Open button. I get the
> >following error msg:
> >"The MS Jet database engine could not find the object <<dbase
> >filename.dbf>>>. Make sure the object exists and that you spell its name and
> >the path name correctly."
> >
> >I have the latest 4.0 jet engine service pack installed (4.0.8618.0).
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newsgroup and not by email.
>

Thank you Gunny! Changing the filename to 8 characters or less resolved the
issue.


"'69 Camaro" wrote:

> Hi.
>
> > I have tried unsuccessfully to open a .dbf file in Access 2003.
>
> Access 2003 will allow you to open this file by creating a linked table to
> it in the current database -- if and only if the file name is no longer than
> eight characters. However, linking to the table may not be what you want.
> If you want a copy of the table to reside in the MDB file, then you must
> import it, not "open" it.
>
> HTH.
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
> Blog: http://DataDevilDog.BlogSpot.com
> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
> info.
>
>
> "FrypanJack" <(E-Mail Removed)> wrote in message
> news:E0F2A272-72B9-49D3-9506-(E-Mail Removed)...
> >I have tried unsuccessfully to open a .dbf file in Access 2003. I
> >downloaded
> > the dbf file from a website. I open a blank new Access db, click on
> > File/Open, select dbase as my file type (I've tried dbase III, IV & V),
> > browse to the dbf file and select it and click on the Open button. I get
> > the
> > following error msg:
> > "The MS Jet database engine could not find the object <<dbase
> > filename.dbf>>>. Make sure the object exists and that you spell its name
> > and
> > the path name correctly."
> >
> > I have the latest 4.0 jet engine service pack installed (4.0.8618.0).
>
>
>

You're welcome! Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"FrypanJack" <(E-Mail Removed)> wrote in message
news:5880165E-B538-48E2-9811-(E-Mail Removed)...
> Thank you Gunny! Changing the filename to 8 characters or less resolved
> the
> issue.
>
>
> "'69 Camaro" wrote:
>
>> Hi.
>>
>> > I have tried unsuccessfully to open a .dbf file in Access 2003.
>>
>> Access 2003 will allow you to open this file by creating a linked table
>> to
>> it in the current database -- if and only if the file name is no longer
>> than
>> eight characters. However, linking to the table may not be what you
>> want.
>> If you want a copy of the table to reside in the MDB file, then you must
>> import it, not "open" it.
>>
>> HTH.
>> Gunny
>>
>> See http://www.QBuilt.com for all your database needs.
>> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
>> Blog: http://DataDevilDog.BlogSpot.com
>> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
>> info.
>>
>>
>> "FrypanJack" <(E-Mail Removed)> wrote in message
>> news:E0F2A272-72B9-49D3-9506-(E-Mail Removed)...
>> >I have tried unsuccessfully to open a .dbf file in Access 2003. I
>> >downloaded
>> > the dbf file from a website. I open a blank new Access db, click on
>> > File/Open, select dbase as my file type (I've tried dbase III, IV & V),
>> > browse to the dbf file and select it and click on the Open button. I
>> > get
>> > the
>> > following error msg:
>> > "The MS Jet database engine could not find the object <<dbase
>> > filename.dbf>>>. Make sure the object exists and that you spell its
>> > name
>> > and
>> > the path name correctly."
>> >
>> > I have the latest 4.0 jet engine service pack installed (4.0.8618.0).
>>
>>
>>