Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: macro refesh

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am importing data from access 2000 into an excel 2000 spread sheet. I am getting the data there from data/get external data/run new query. I save the query.
    I want to refresh the data. When this happens the column headings get changed from total sales to SUMOF total sales, which is the name inthe access data base. Even when i write a macro to handle the refresh and to change the column heading to total sales it still goes back to this SUMOF.
    Anyway to prevent this or to get it to go back to total sales ?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It is much simpler to Export from Access to Excel.

    Go to Macro's tab in Access click new. Then on the "Action" Line select "Transfer Spreadsheet"

    In the Arguments below select Export, type in the name of your query( says table name)
    and the Path to where you want to export to.

    you can tie it in with a button on a form

    Oh I always change those "Sum Of..." by going to the field in design view of query. right click field and select properties type in a name under Caption.

    Ziggy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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