Results 1 to 5 of 5
  1. #1
    planaigeist is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jun 2019
    Posts
    2

    Access 2003 nach excel oder sql

    Hallo ihr Spezialisten,
    ich bin schon ein etwas älterer Zeitgenosse und habe aus 2005 Access Dateien die vom heutigen Access nicht mehr gelesen werden können. Es gaht um 4 Datensätze .mdb. Ich suche eine Lösung diese Daten in einer Excel Datei darzustellen oder einer SQL Datenbank. Wer hat eine Idee und kann mir helfen. Angeblich soll es eine Lösung über Libre Office geben, nach ca. 20 Punkten die dazu notwendig sind habe ich aufgegeben.


    Hans

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,158
    You should be able to link to the tables in a new access database or excel to get to the data.

    Alternatively you can pay someone a small fee to convert the files to the later format, assuming they are not password protected.
    If they are but you can prove you have a legal right to them the a slightly larger fee would get them unlocked and converted.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    planaigeist is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jun 2019
    Posts
    2
    Hi Minty, can you do this for a little fee? i can send you an example (4 files) you can send me an E-Mail hans at selbach dot at
    Hans

  4. #4
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,158
    I don't have the relevant tools / versions of access available very easily at the moment.
    I'll see if I can get someone to assist.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Hi
    Minty brought this to my attention.
    I can do conversions for a small fee.
    Please read this link http://www.mendipdatasystems.co.uk/d...ion/4594459112.
    If interested, you can email me using the link in my signature line
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. priority oder of commands
    By Jen0dorf in forum Access
    Replies: 3
    Last Post: 01-23-2016, 01:14 PM
  2. Formatting Excel workbook from vba in access 2003
    By nyneave in forum Programming
    Replies: 29
    Last Post: 10-28-2012, 10:32 PM
  3. Export from Access 2003 to Excel 2003 - missing fields
    By Jack Sheet in forum Import/Export Data
    Replies: 1
    Last Post: 02-29-2012, 04:09 PM
  4. import excel file to access 2003 yes, access 2007 no
    By stapik in forum Import/Export Data
    Replies: 9
    Last Post: 07-27-2011, 07:09 AM
  5. MS Access 2003+Ms Excel 2007 Issue
    By putnum in forum Access
    Replies: 3
    Last Post: 12-20-2009, 09:24 PM

Tags for this Thread

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