melbury

Import (drag and drop) from xlsx does not import field names

Discussion created by melbury on Feb 23, 2012
Latest reply on May 3, 2012 by melbury

Hi, this seems the right category - apologies if not...

 

I have a repeatable challenge with drag and drop into FM 11

 

I export an XLSX from Access - it looks fine in excel - all standard format text I believe

 

When i import it does not bring headers as field names

 

HOWEVER if I open the file in excel and 'bold' top row of headers and close - then drag and drop - the column headers are identified in FM!

 

Also if I export from Access with formatting it still doesn't show headers on FM import - again if I open in XL then un-bold and then bold again FM reads field name headers

 

Bizarre - any ideas?

 

Thanks

 

Mike

Outcomes