|
[VIEWED 3682
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
hulakibro
Please log in to subscribe to hulakibro's postings.
Posted on 08-25-06 6:04
AM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
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
|
| |
|
|
|
|
AwaTar
Please log in to subscribe to AwaTar's postings.
Posted on 08-25-06 7:12
AM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
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
|
| |
|
|
hulakibro
Please log in to subscribe to hulakibro's postings.
Posted on 08-25-06 10:14
AM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Thank you Awatar. I appreciate your help
|
| |
|
|
Icanfly
Please log in to subscribe to Icanfly's postings.
Posted on 08-25-06 2:25
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
You can save the excel file as TAB Delimeted Text file and import to any table of Any Database.
|
| |
|
|
kaam_Krodh_loav_Moah
Please log in to subscribe to kaam_Krodh_loav_Moah's postings.
Posted on 08-25-06 2:25
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
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
|
| |
|
|
Hellbound
Please log in to subscribe to Hellbound's postings.
Posted on 08-25-06 3:32
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
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.
|
| |
|
|
AwaTar
Please log in to subscribe to AwaTar's postings.
Posted on 08-25-06 4:53
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
If your data does not have any richtext or unicode characters then probably the CSV solution is the fastest and easiest one.
|
| |
|
|
hulakibro
Please log in to subscribe to hulakibro's postings.
Posted on 08-25-06 5:01
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
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..
|
| |
.png)
