NEO
Member
Hi Can anyone help me out in giving me the steps for uploading a excel data into a custom JDE file using Interoperability function.
Thanks in Advance for the help.
Venkat
Thanks in Advance for the help.
Venkat
tallam
Active Member
hi,
do u want to upload data from xl-grid-jde table,then u can use xl imort and export option avalable ongrid, or
Why cant you go for an UBE and read the xl file by using *File I/O* business function to read line by line from the file and do all your validations and inset into the JDE tables.
tallam
do u want to upload data from xl-grid-jde table,then u can use xl imort and export option avalable ongrid, or
Why cant you go for an UBE and read the xl file by using *File I/O* business function to read line by line from the file and do all your validations and inset into the JDE tables.
tallam
Hemant
Active Member
Hello
I am actually trying to read an excel file in a Table Conversion application. The Table conversion application will read the excel file line by line and transfer the data to a transaction file. For the time being, I have to convet my excel file into CSV. But I would like to read the excel file directly, if that is possible.
Can you please suggest any Business Function that can do that?
Thank you for your help.
Regards,
Hemant
I am actually trying to read an excel file in a Table Conversion application. The Table conversion application will read the excel file line by line and transfer the data to a transaction file. For the time being, I have to convet my excel file into CSV. But I would like to read the excel file directly, if that is possible.
Can you please suggest any Business Function that can do that?
Thank you for your help.
Regards,
Hemant
sviardot
Reputable Poster
could use custom bsfn with odbc driver (see www.ocode.net) but beware of excel's version you use.
