I am using a data import from one Excel workbook to another.

Data -> Import External Data -> Import Data -> Select External Excel Source -> All default values include 'first row is column header'

The Import is replacing some of my headers with things like:

NonName, NoName1, F4, F5, F6...

Sometimes it keeps the column headers, but mostly it is replacing them with jibberish.

I am using Excel 2002. Any ideas?