Database query in Excel

[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

 

[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

 

[SHMUNCY]

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