Import excel data with no header to AP
You can’t make SmartConnect use the first row as headers when using an ODBC connection. It will automatically ignore the headers and provide data. You can give your expression an alias which will be used as a column header.
If you want to use your source document’s headers you can use a Microsoft Excel data source and it will automatically use the headers you used in your source document.
If you saved your source document as a text file, you can select Text File as your data source. You can go into the schema configuration and check the box “Has Column Headers.”
If you would like to submit an answer or comment, please sign in to the eOne portal.