How get col headings when export to Excel ??

R

Rebecca

When I use the 'TransferSpreadsheet' command to export my
query to Excel, how do I get the column headings from my
query in there? I can get them in the first spreadsheet
row, but that is not what I want, I want them as column
headings in Excel?
I've tried the 'Has Field Names' parameter as Yes and No
but it does not do what I want.
I'm using Access 2000. HELP my manager needs this
yesterday!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
White space above heading inconsistently applied 1
Solved Disk Full error message when exporting PDF 0
Need Help with a VBA subroutine 0
Making a macro only work on certain files 2
Integrating information from Word to Excel (not mail merge) 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Excel does not accept text format! 0

Top