ronan.healy (9/25/2014)
Can an xlsx excel file be read in using a flat file connection.I tried a few different column delimiters like tab vertical and coma but still doesn't come in right
That's because an Excel file is not a flat file. Use the Excel connector, or (preferred) get the data exported to CSV and use that instead.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin