Copy Access Table/Query Data to Excel without Field Header

[sxschech]

Is it possible to copy data from an access table/query into excel without it including the Field Name header? I would like only to paste data to replace existing cells in Excel, and the header adds an extra row which messes things up.
Example:
[tt]
Access Table/Query

Report_Date Status Totals
--------------------------------
12/9/2005 Complete 5
12/9/2005 Pending 18
12/9/2005 Other 2
[/tt]

I highlight the three values from the Total Col., copy, switch to Excel and Paste. What I need is:

[tt]
A B C
----------------------------
1|Complete 5
2|Pending 18
3|Other 2
4|Net 0
[/tt]

This is what I get when I paste:
[tt]
A B C
----------------------------
1|Complete Totals
2|Pending 5
3|Other 18
4|Net 2
[/tt]

Pasting one cell above the start position is not an option.

 

[SkipVought]

Hi,

There is functionality in Excel to query a table in a database, and include or exclude column headings.

Furthermore, if is often preferable to query a table to return a subset of data based on some criteria rather than dump all the data.

So take a look at Data/Get External Data... in Exsel and it can do exacly what you have asked.

Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}