Results 1 to 8 of 8

Thread: Export to Excel

  1. #1
    gdboling
    Guest

    Export to Excel

    Is there a way to export data in a table to a pre-formated Excel spreadsheet? When I export, it always overwrites the entire Excel file to a new unformated one.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export to Excel

    You can export from access (although I never have), I normally import from Access table/queries to pre-formatted excel spreadsheets.

  3. #3
    gdboling
    Guest

    Re: Export to Excel

    how and where do you do that?

  4. #4
    gdboling
    Guest

    Re: Export to Excel

    cool, thanks, that does help. So refreshing will append data and not overwrite?? Or does it overwite all the cells just not the formatting of them.

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export to Excel

    Once you've created your Excel Spreadsheet, select the starting cell location, click on Data|Get External Data|Create New Query (or Run Database Query), and follow the wizard. Once this is done and you've saved the xls file you have the option to Refresh the data any time you like. As far as exporting from access to cells in excel, as I say that's something I believe can be done through code, however I've never done it. Hope that helps. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  6. #6
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export to Excel

    No, it will overwrite existing data but will leave the formatting alone. Think I see where you're going, it is undoubtedly possible to append within excel (expand an area in a sheet) but that's a bit out of my scope. I normally grab summary information from an access query and do my detail work using Access reports.

  7. #7
    gdboling
    Guest

    Re: Export to Excel

    That will work. Thanks for you help!!!

  8. #8
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export to Excel

    You can link to an Excel worksheet and append into it via an append query in Access.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

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