spreadsheet(xls) to IDOC

[Guest_imported]

Any ideas will help me a lot about conversion from Spreadsheet to IDOC format.
Iam using DatastageTx 7.5,Os=Windows2003.

 

[SeriesConsumer]

Processing xls format is not possible with standard means of DSTX (at least not with a reasonable amount of work). You could, however, try to save the spreadsheet in XML format and process that. To my knowledge, everything that's possible in xls is also possible in XML. Or you could access the spreadsheet via ODBC (but that will require a fragile Windows infrastructure). Basically it depends if you are going to process the spreadsheets permanently or rather seldomly, i.e. it would be acceptable having additional manual tasks to perform.

Don't know what IDOC format you mean. There are several formats/standards having such an acronym.

 

[BocaBurger]

You can use ODBC adapter and define the ODBC source in Windows to read Exel spreadsheet data, this does work well. Since this is running on Windows, the infrastructure is limited to Windows. You could also export / save the spreadsheet as csv and use the file adapter. You can also send it to Access and use ODBC there, or even go through Acess to SQL Server.

Depends on what the source of the data is. Could write VB to get it to the best location / format you need to send through the map.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!