Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397

    Question Unanswered: How do I import data from DBase file to MDB

    Hi Gents,

    One of my client has very old db program created in Dbase (ver might be 5 or 6 dont know). I can see the files with extension DAT, EXE, BAK etc....

    I am planning to import one important file which has master data of items for car spare parts. I am expecting upto 50,000 records might be holded by files.

    I am confused which way to get the data. I never try to import from Dbase file. Is there any particular way to import this file or just to use DoCmd.TransferDatabase....

    Please advise.
    With kind regards,
    Ashfaque

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    As a once-off, I'd just try with File - Get External Data - Import.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    I ll back StarTrekker idea first

    Get the data in there first then have a look around
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397
    Thanks to both of you gentlemen,

    I will try first then will come back to you if there goes wrong.

    Thanks.
    With kind regards,
    Ashfaque

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •