TransferSpreadsheet - import xls using second row as field names

[sampun]

I'm trying to import a spreadsheet that has field names in the second row with the first row as a blank row (ie null values). Is there a way of using the second row as headings?

Thanks.

 

[The_Doc_Man]

Not via a wizard, I think. The wizards are great - but dumb. I think you can say "Don't import the first row" but you lose the chance for field names to come from there.

However, God knows I'm a pragmatist. Rather than moving Heaven, Hell, and some appreciable fraction of the Earth, just make a copy of the spreadsheet, delete the null row, and import the amended copy. Some things just ain't meant for VBA.