Export without Field Names

  • Thread starter Thread starter Sue McKeating
  • Start date Start date
S

Sue McKeating

Hello All

I need to export a table to excel, but not the field
names, as this excel file is then picked up from an SAP
application. Does anyone know how to do this. I see in
the help that even is you say no to field names they are
still exported over.

Many thanks

Sue
 
Try exporting using automation instead.
Copy & Paste the first subroutine from this web page into
a new module:
http://www.mvps.org/access/modules/mdl0035.htm
Be sure to go in and change the Set rs statement:
Replace "Customers" with the name of your Query or Table
you wish to export.
Then from the Tools Menu select References and check
Microsoft Excel 8.0 Object Library
Then on any form create a new command button (cancel the
wizard).
Right-click on the button and select Build > Code Builder
Then type sCopyFromRS. Then run the form.
When you click the button it should open a new Excel
Spreadsheet - without column headings.
The other subroutines on the form are for use with an
existing worksheet or template.
Hope this is what you were looking for.

jmonty
Joel Montalvo
 
Hello Joel

It worked a treat - many thanks for your quick response.

Kind Regards

Sue
 
Back
Top