Problem importing tables with MS Query due to lack of column headers

[Glory]

SELECT *
FROM `C:\Documents and Settings\gendetlab\Desktop\hwvdata`.`'Sheet1$'` `'Sheet1$'`
UNION ALL
SELECT * 
FROM `C:\Documents and Settings\gendetlab\Desktop\hwvdata2`.`'Sheet1$'` `'Sheet1$'`

This code works perfectly, except that I have to make column headers bold before they MSQuery will recognize the tables as 'valid'.

If I have to open the files to make the column headers bold, the entire purpose of the code (to speed up the copying process) will be defeated.

Can you help explain why this is happening? Is there a way to force MSQuery to recognize the used range of a sheet as a table, no matter what its contents look like?

To just, treat the first row as a series of column headers?

 

[Glory]

And, now I'm noticing that making the column headers bold isn't a sure-fire solution.

The only way will be to force MSQuery to recognize what it grabs from each sheet as its own table.

Is there any way to force that behavior?