Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Large file conversion

Former Member
0 Kudos

Has anyone out there had to deal with a large file conversion, i.e., the data to be loaded into R/3 is very large, too large to fit in an Excel file. Originally we suggested to the conversion team to put their data in an Excel file and we would flag all the records that were not loaded so they could find them easily and correct the data. However, now they tell us the number of records is too large for an Excel file and they DON'T want to split the file up into manageable pieces.

They also don't want to use a BDC session to correct the errors.

Any sharing of past experiences would be appreciated.




Former Member
0 Kudos

Depends on the skills in your team perhaps; when we've hit Excel limits in the past then Access has been the next tool of choice (often because it's already installed on the desktop). This means you could, if you wanted, knock up a bit of RFC code in Access VB and + a "Call Transaction" function module in ABAP to do the file conversion, and they could correct any fails / bad data from within the Access system. It's not going to perform as well as an ABAP with the usual "<i>load dataset into memory, do lots of call transactions, write the errors to a BDC session</i>" though (and run times could be critical to your project).