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