Results 1 to 4 of 4
  1. #1
    MarshaPav is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    2

    Trouble importing/linking dbase file


    I have a scheduled task that runs in Access 2010. It reads a .dbf file and creates an Excel file that is used by other processes. It works fine on my old PC, a 32-bit XP machine. I am not able to get it working on my new 64-bit Windows 7 machine. Both are running Access 2010, but my old PC is running 32 bit and my new one is running 64 bit, if that matters.

    In trying to figure out the problem, I went into Access and tried to link or import the file using the External data menu buttons. I am getting a message "External table is not in the expected format". I can go to my old PC and do the same thing and it imports the file. I have also tried this on a server with 32-bit Access and have the same issue as I do on my new PC. Is there something else I need to set up on my new PC to be able to import or link a dbase file?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Bing: Access 2010 dBase

    Here is one possible cause: http://answers.microsoft.com/en-us/o...9-1312fd83d394
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    MarshaPav is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    2
    Thanks for the response.

    Access doesn't crash, it just won't open the file. My old 32-bit PC with Access 2010 will open the file with no problem. My new 64-bit PC with Access 2010 gets the message "External table is not in the expected format".

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Apparently you aren't the only one having issues with Windows 7 64-bit accessing dBase tables. Unfortunately, I can't find a solution. I will have to try this weekend and see if I get same issue.

    Unfortunately, I can't get my home Access to set up ODBC connection, something about missing drivers, which I tried to download and install but did not help.

    I have no trouble setting up ODBC and connecting to dBase tables at work running Windows 7 64-bit and Access 2010 32-bit.
    Last edited by June7; 12-14-2013 at 06:05 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Trouble linking records
    By kruseanderson in forum Access
    Replies: 9
    Last Post: 04-16-2013, 06:12 PM
  2. Trouble importing date from CSV
    By NickP in forum Import/Export Data
    Replies: 1
    Last Post: 01-13-2012, 04:12 AM
  3. Linking dbase with website
    By pp100 in forum Database Design
    Replies: 2
    Last Post: 08-24-2010, 05:56 AM
  4. importing Dbase files
    By dzawicki in forum Import/Export Data
    Replies: 2
    Last Post: 01-14-2010, 05:43 PM
  5. Importing Excel Sheet into Access dbase
    By tonystowe in forum Import/Export Data
    Replies: 0
    Last Post: 12-08-2006, 11:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums