I have an Excel file I'd like to use in Integration Manager. I can't get it to work.
I don't want to save it as a csv or txt file so I am trying to use a Source adapter, either simple or advanced ODBC. I get as far as selecting the Excel sheet and it tells me it's not the proper format. It is a normal spreadsheet with headings! I can't find anything in the help documentation or user manual.
thanks
I don't want to save it as a csv or txt file so I am trying to use a Source adapter, either simple or advanced ODBC. I get as far as selecting the Excel sheet and it tells me it's not the proper format. It is a normal spreadsheet with headings! I can't find anything in the help documentation or user manual.
thanks