Can you copy query results from Access to Excel without headers?

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

Guest

I want to copy my query results to existing excel files - but each time I do,
the headers from Access come over as well. Is there a way to only copy the
data in a query without the column headers getting copied as well?
 
The only way I could think of would be to use Automation to put the data
into the spreadsheet, rather than using TransferSpreadsheet or OutputTo.
 
You must log in or register to reply here.

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

Transferspreadsheet - insert rows with no header 1
column header needs symbol 2
Access #Error & Excel Pivot 0
CSV file losing "#" in column headers 1
INSERT to excel file 4
Is there anyway to copy a row off of MS Access without getting the 5
Column Headers in Access Tables 2
Extract Headers from Crosstab query 2

Back
Top