Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Location
    NH
    Posts
    3

    Angry Access Export to Excel Header Problem ..

    I have an access db that builds and exports multiple spread sheets to a template.

    DoCmd.TransferSpreadsheet acExport, 8, strtablename, "\\templates\output\" & strfilename, True, "TransactionInformation!b4:I4"

    The True/False is supposed to designate whether to use headers, but in regardless of choice, the headers from the table exported is placed into the spread sheet.

    Is there a way around it so that only the data, no headers, are exported to the spreadsheet?

    (my co-worker found on msdn that the headers will always be exported, regardless of true/false.... figures)

  2. #2
    Join Date
    Feb 2002
    Posts
    64
    I was just dinking around with a macro doing the TransferSpreadsheet action and sure enough whether you put Yes or No in the Field Names, they get transferred.

    However, when I did the TransferText action and chose No to Field Names, they did not transfer. When you choose csv as the file extension, it is considered an Excel file.

    I don't know if this will be structured enough for what you need, seeing as you specified the transfer range, but thought I would throw it out there for you to consider.

  3. #3
    Join Date
    Oct 2001
    Location
    NH
    Posts
    3
    Good thought ... but I need to transfer to the specific ranges....

    Last edited by CarbonTwelve; 05-17-02 at 11:03.

Posting Permissions

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