hey guys, i am trying to get 7000 lines from excel to SAP.. but I have to
do it one line at a time. That one line is only in A1, B1, C1 etc.. cells.
so basically i have to copy that cell data and paste on SAP 7000 times.
Anyone can help me with access VBA code that can do a robo-tech job?? This
robo-tech job would auto copy and paste on SAP and save, then auto copy and
paste and then save.. 7000 times.. just a basic one would be cool as well..
I will format it after that..
Thanks

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

Thank you Awatar.
I appreciate your help

You can save the excel file as TAB Delimeted Text file and import to any table of Any Database.

Hi,
First check if you have any tools that can import data to SAP from sources like excel or text file with some delimiter, if not then first transfer this spreadsheet to SQL server table by DTS transfprmation or transfer to MsAccess by importing wizrd. Then you should be able to move it to SAP

I would go with Icanfly's easy approach. First convert the file to tab or comma quote delimited text file. However, you have to be careful when you convert the file because you may lose some data or the format of data can be messed up. After that, you should be able to import the text file to SAP or any other database.

If your data does not have any richtext or unicode characters then probably the CSV solution is the fastest and easiest one.

Well, I am not trying to dump the whole 7000 excel lines at once... i need to copy one line and paste on sap then copy the second line, then paste, so on and so forth..