1 Reply Latest reply on May 3, 2012 10:15 PM by melbury

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

    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