Database query in Excel

A

Al

Hi I am using Microsoft query to bring some data into Excel - is it
possible to stop the field names coming over as well. i need to place into
a preformatted worksheet, which already has the field headings.

Thanks
J
 
C

CLR

If you recorded a macro to do the Query, then therein you will see a line
which reads......

..FieldNames = True

Just change to True to False

Vaya con Dios,
Chuck, CABGx3
 
S

SHMUNCY

You can right click on the data, click "Data Range Properties" an
uncheck Field Names
 
Top