Import excel data inot grid

[Rishi]

Hi

Could please give your suggestion on How to import the exccel data into Grid apart from "import" Grid option and without making the Flat file from Excel file.

Thanks
Subash.S

 

[TimPierce]

There are some Business Functions that could help you if you use a flat file, for example:

B76B0220 - Fetch line from flat file
B4700240 - Import flat file to JDE file

Why can't you use the 'import' facility?

 

[Rishi]

Hi Tim

Thanks for your advice, My issue is i don't know wht will be the input file format for me to upload data into grid . It might be a Excel file or a flat file.

If the Input is flat file, i will try with that BSFN.
if suppose the input file is Excel, is there any option other than this "Import" to load data into grid?.

Thanks
Subash.S