Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    16

    Unanswered: export mdb database to excel

    Is there any way to export mdb database to excel without writing queries or exporting one table or query or report at a time?
    ----------------------
    IMPOSSIBLE has another way of saying - I M POSSIBLE

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ehhhh... no?

    Is it possible to export a hammer into a screwdriver?

    If you want to export all of the tables into separate tabs on an excel workbook, that's one thing. Access and Excel aren't the same thing though. You can't just convert a whole mdb to an xls, they're apples and oranges.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Aug 2008
    Posts
    16
    erm, i was talking about in seperate tabs only. i didn't mean all on the same sheet
    ----------------------
    IMPOSSIBLE has another way of saying - I M POSSIBLE

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why would you want to?

    You can just copy and paste data from a table's datasheet view to an Excel sheet. If any table has lots of records (> 65535) then you're gonna have some fun
    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

  5. #5
    Join Date
    Feb 2013
    Posts
    4
    hmmmmm

    Yes dear..... If you don't want any query to export data to excel then you can use tool to export data. Use this TechNet Access To Excel Converter Helps In Database Migration Process I think it will help you into resolving your query. Take a look on it.

Posting Permissions

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