Export Data only (do not export headings)

[shart00]

A query runs. What is needed is for the user to take that data and drop it into an excel spreadsheet without carring over the column headings because the excel and database do not share the same headings.

Currently the user must anticipate that an extra line will be copied in when using CTRL C and CTRL V and then must delete the headings row.

Is there away to set it up in Access so that the column headings do not show or simply do not export when using CTRL C. I need to stay away from anything too complex or else the users will reject the database.

 

[SQLSister]

Why not just fix the query so that it displays the headings
you want?



Questions about posting. See faq183-874

 

[shart00]

That would still mean that everyday when the CTRL C is used they would have to go back and delet the row of headings that is copied over.
Trust me, I need to make this as simple as possible or else all the work will be trashed.

 

[pbrodsky]

But you don't need to copy and paste to get the data into Excel. Just use the menu option 'Data: Import External Data, and refer to your Access query. Afterwards, you can just do a Refresh Data to update the data from the same query.