Integrate from Excel

[barbola]

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

 

[njtech2008]

Hi Barbola,

What kind of data you need to import from Excel file to GP?

Regards,
Nj

 

[swabunn]

Make excel heading does not have spaces betwen words for example vendor id, it should be vendorid.

and then match each field with windows fields in the intergration manager