cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Read of Excel file (.XLSX) in SAP BODS

0 Kudos
2,209

error-log-bods.jpgfile-format-bods.jpgMy source file is Microsoft excel (.xlsx), while reading source file, most of file formats do not read .xlsx but read only .xls files even though the File Formats are created in similar manner. Could you please help me to fix the issue in SAP BODS job?

Error am facing in BODS Error Log below

File Format

Accepted Solutions (0)

Answers (2)

Answers (2)

denise_meyer
Advisor
Advisor
0 Kudos

It is complaining about path and permissions. Can you check that the path is valid and that the user that starts the job server has permissoins to see the file?

0 Kudos

What edition of BODS do you have ? BODS 4.X will support .xlxs format.

Whilst creating the file format did you use Import schema option to get the columns details ? Is it working ?

0 Kudos

version2.jpgSAP BODS 4.2

0 Kudos

Yes Vinayak,

While creating file format, I imported schema (Structure) and its completely came up as it is in file. But while reading it is throughing error in .XLSX format. But surprisingly while set .XLS then its reading fine.