External table is not in the expected format error message when importing dbf file into Access

Posted on 2004-11-30
Last Modified: 2010-08-05
dbf file imports no problem into 98SE machine with O2K with all the updates.
Same file into O2K with all the updates on a 2KPro machine with all the updates yeilds the above error.

Please Help
Question by:ssurvis
    LVL 41

    Expert Comment

    Have you updated MDAC?

    This contains the latest ODBC drivers and ISAMs, which the office service packs don't.

    Author Comment

    MDAC updated. Same problem.
    Some dbf files will open on 2KPro or XPPro machines.
    LVL 54

    Accepted Solution

    Tried to install the latest Borland BDE drivers ?

    LVL 54

    Expert Comment

    When you use the ODBC file to link a table, then you'll be able to see the build connection string when you open the linked table and select the properties (Button with hand an white sheet).
    There will be a Connection property with the information.
    This string can be set from code using:

    Dim td As DAO.TableDef
    Set td = CurrentDb.TableDefs("table name")
    td.Connect = "<here the needed link>"

    Clear ?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Title # Comments Views Activity
    Access DLookup 18 22
    error on vba access function, ByRef 4 27
    Running Sum Issue 7 21
    Running Sum Help 31 19
    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now