Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Integrate from Excel

Status
Not open for further replies.

barbola

Technical User
Feb 27, 2003
1,132
CA
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
 
Hi Barbola,

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

Regards,
Nj
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top