Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1721
  • Last Modified:

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

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
0
ssurvis
Asked:
ssurvis
  • 2
1 Solution
 
shanesuebsahakarnCommented:
Have you updated MDAC?

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en

This contains the latest ODBC drivers and ISAMs, which the office service packs don't.
0
 
ssurvisAuthor Commented:
MDAC updated. Same problem.
Some dbf files will open on 2KPro or XPPro machines.
0
 
nico5038Commented:
Tried to install the latest Borland BDE drivers ?

Nic;o)
0
 
nico5038Commented:
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>"
td.RefreshLink

Clear ?

Nic;o)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now