Export Data to Excel Problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there;

I am working with an Access 2003 database, and I need to export call data to
an excel spreadsheet, which is then emailed to a supervisory group. I have a
macro on a command button that opens a REPORT that gathers the necessary data
and is suppossed to format it for an excel spreadsheet. I have the data
coming across ok for the most part. However, my problem lies in the headings
for the Excel spreadsheet. The headings that come across are the call
function names that I have set up for the variables, and they are not very
reader friendly. My question is this: Is there something that I can add to
the REPORT form that prints this heading information out?
 
The export process uses the field name (or the alias for the field name)
that is in the query. So use an alias in the query that has the desired
names you want for column headers.
 
Back
Top