Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19

Importing from Access 2

  1. #16
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    13
    Quote Originally Posted by ridders52 View Post
    All done. Hopefully the attached is what you wanted



    2 things slowed me down a bit:
    1. Not having any of the linked tables
    2. Not having a default printer on my VM with Access 2000 - I had to fake a printer to open the file!

    These are the steps I did using various versions of Access:
    1. I opened it in Access 2 so I knew that was the file format
    2. Reopened in A2000 and converted the format
    3. Reopened in A2010 and converted to ACCDB - removed the utility.mda reference which doesn't exist in ACCDB files
    4. Reopened in A2016 so the references updated - otherwise should be identical to 2010 version

    Due to not having all the linked tables, I can't really check its OK. I need to leave that to you

    I'm attaching all 3 converted versions in case you have problems with any of them
    Let me know whether it seems OK & I'll then delete all files from my PC
    Omg thank you! You've saved me hours and hours of work! Good karma coming your way

  2. #17
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,471
    You're welcome.
    First time I've done it for anyone else so I'd forgotten that I'd need a dummy printer
    Think I may start offering this as a service via my website
    Colin (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment

  3. #18
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    13
    Quote Originally Posted by ridders52 View Post
    You're welcome.
    First time I've done it for anyone else so I'd forgotten that I'd need a dummy printer
    Think I may start offering this as a service via my website
    Once I attached the tables it worked perfectly. Just gotta make it look less 90s now lol. You should. You saved me days of work. Thanks again.

  4. #19
    ridders52's Avatar
    ridders52 is offline Voodoo Is Practised
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    2,471
    LOL!
    Making it look modern is something I'll leave to you....

    EDIT: I've also sent you a PM
    Last edited by ridders52; 11-01-2018 at 06:30 AM. Reason: Added sentence
    Colin (Mendip Data Systems), Website, email
    If this has helped, please click the star button and leave a comment

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing .WDB into Access
    By walpy in forum Access
    Replies: 2
    Last Post: 01-23-2014, 11:14 AM
  2. Importing data from PDF to Access
    By jigg14 in forum Import/Export Data
    Replies: 1
    Last Post: 02-09-2012, 11:57 PM
  3. automate importing access
    By mcchung52 in forum Access
    Replies: 1
    Last Post: 01-21-2012, 01:20 AM
  4. Importing XML to Access
    By herbc0704 in forum Import/Export Data
    Replies: 1
    Last Post: 06-02-2011, 03:30 PM
  5. Importing Txt file to Access
    By fuxy in forum Access
    Replies: 6
    Last Post: 04-25-2011, 06:58 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