Not sure how SAP works but you can transfer those 7000 records to Access or SQL Server quite easily. You can either connect to Excel spreadsheet from Access or do 'Import' from SQL Server or write openrowset query to the Excel. I am assuming there is some easy way to get data from Access or SQL Server to SAP i.e. via wizard. If you are unable to get satisfactory answer from this forum you can post your questions at http://tek-tips.com/ under Home>Forum>Programmers>Languages> VBA Visual Basic for Applications (Microsoft) Forum