Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Orlando, FL
    Posts
    2

    Unanswered: MS Access Export to .xls

    I am a very beginner when it comes to VB coding and am looking for some sample source on how to export a table from MS Access to a spread sheet that can be eventually imported back into the same database. Can anyone please help???

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: MS Access Export to .xls

    Use "Analyse it with MS Excel" menu on your menubar. Alternately you can right click on your table and select "Export" option. Make sure to pick file type as *.xls.



    Originally posted by Roger5755
    I am a very beginner when it comes to VB coding and am looking for some sample source on how to export a table from MS Access to a spread sheet that can be eventually imported back into the same database. Can anyone please help???

  3. #3
    Join Date
    Oct 2003
    Location
    Orlando, FL
    Posts
    2

    Thanks anyway

    I am looking for sample "source code" to do this so I can create a button to automatically export all tables to spread sheets with the same name but with a .xls extension. I already know how to export tables manually.

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Version of Access? 2000 doesn't have the Excel references as part of the standard package ... 2002 does ( you can export/create/whatever programmatically) ...

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    You can create a command button an paste the next code as it click event:

    DoCmd.OutputTo acOutputTable, yourExportTableName , acFormatXLS, path & ExportedName & ".xls"



  6. #6
    Join Date
    Feb 2013
    Posts
    4
    Ahh...
    yes you can easily import access database in excel sheet with same database by
    Access To Excel Easy Converter For Fruitful Results in SQL, JavaScript

Posting Permissions

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