Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    TransferSpreadsheet Macro (Access 2000)

    I have a macro to export data to excel using

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: TransferSpreadsheet Macro (Access 2000)

    The headings argument dictates whether Access exports the data *including* the headings into a spreadsheet. It doesn't tell the action to insert the data into an existing sheet that already has headings.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: TransferSpreadsheet Macro (Access 2000)

    oh I see! Will I be able to that though (Transfer data into a sheet that contains headings?)? Thanks Charlette

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: TransferSpreadsheet Macro (Access 2000)

    The transfer of field names always occurs, regardless of the setting you specify for "has field names" - that is really used for importing rather than exporting. In addition, an export always puts the data in a new worksheet. The real confusion here stems from the fact that the same action is used for both import and export. Check out the help for "TransferSpreadsheet" to get further details.
    Wendell

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: TransferSpreadsheet Macro (Access 2000)

    Thank you you guys, What i've done was append the record to a table and changed the feild names and then selecting records using a query and then transferriong it. Long mission but it works.
    Thanks alot for those who helped me.
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: TransferSpreadsheet Macro (Access 2000)

    Take a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=70610&page=0&vie w=collapsed&sb=5&o=186&vc=1>this thread</A> and see if that helps you.
    Charlotte

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: TransferSpreadsheet Macro (Access 2000)

    <hr>The transfer of field names always occurs, regardless of the setting you specify for "has field names"<hr>
    That depends on the spreadsheet type and version.
    Charlotte

Posting Permissions

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