Results 1 to 4 of 4

Import from old Dbase

  1. #1
    steenesse is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    6

    Import from old Dbase

    I'm trying to import from an old Dbase file and if I try to import from file I get an "Out of memory" error and if I set it up via ODBC, I get the message that I can't use dBase via ODBC. I have no issues importing in Excel or Open Office Base. Anybody come across that issue ? I suspect that it maybe an older format than Access is expecting, but I see no settings when importing.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    6,841
    you must have the correct dBase ODBC driver.
    can you export dBase to xl , then to access?

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    7,723
    Do you know anyone that has an A2000, A2007 or A2010 version? I can still link to a dBase file in A2010.
    If you still have a dBase program, export the data to a csv (txt) file, then import the to A2016.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  4. #4
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    6,131
    depends on the version of access you have

    MS dropped support for dbase with 2013 but restored it for 2016. See this link - you may need to install some updates

    https://support.office.com/en-us/art...ce_2007_-_2010

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

Similar Threads

  1. DBASE and sub DBASE
    By WillemTWC in forum Database Design
    Replies: 3
    Last Post: 02-16-2018, 04:49 AM
  2. dbase format and VBA2013
    By leonardo.massei in forum Programming
    Replies: 3
    Last Post: 11-04-2016, 07:34 AM
  3. How to import a dBASE table in Access 2013
    By Jocoel in forum Import/Export Data
    Replies: 3
    Last Post: 11-05-2014, 06:08 PM
  4. dBase import/link issue
    By SteveF in forum Import/Export Data
    Replies: 3
    Last Post: 04-16-2012, 04:19 PM
  5. Best approach for Absence DBase
    By JohnMc in forum Database Design
    Replies: 1
    Last Post: 11-17-2011, 11:00 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
  •  
Tech Forums: Microsoft Office Forums