How to export data from SAP to Excel

myrka · Joined: 04 Oct 2007 Posts: 2

How to export data from SAP to Excel ?

OLE ? ABAK ?
VBA ?
others ?

Marcin Karlewski

Archived from group: microsoft>public>vb>ole>automation

Paul Clement · Joined: 04 Oct 2007 Posts: 1560

On Tue, 13 Feb 2007 22:37:22 +0100, "myrka" wrote:

¤ How to export data from SAP to Excel ?
¤
¤ OLE ? ABAK ?
¤ VBA ?
¤ others ?

How about CSV or XML? Unfortunately I don't much of anything about exporting data from SAP.

Paul
~~~~
Microsoft MVP (Visual Basic)

how can I export linked tables to excel? Hi All, I have to linked tables I wish to export to excel. What code do I need to do so? = "SELECT SIR.* FROM ICP " & _ "INNER JOIN (SIR INNER JOIN SIRperIR " & _ "ON SIR.Id_SIR = SIRperIR.SIR) " & _ "ON ICP.Id_ICP = SIRperIR.IR " & _ "

how can I export linked tables to excel? Hi All, I have to linked tables I wish to export to excel. What code do I need to do so? = "SELECT SIR.* FROM ICP " & _ "INNER JOIN (SIR INNER JOIN SIRperIR " & _ "ON SIR.Id_SIR = SIRperIR.SIR) " & _ "ON ICP.Id_ICP = SIRperIR.IR " & _ "

how can I export linked tables to excel? Hi All, I have to linked tables I wish to export to excel. What code do I need to do so? = "SELECT SIR.* FROM ICP " & _ "INNER JOIN (SIR INNER JOIN SIRperIR " & _ "ON SIR.Id_SIR = SIRperIR.SIR) " & _ "ON ICP.Id_ICP = SIRperIR.IR " & _ "

Get Excel Data All, Using VB 6.0, I need to get the data out of an Excel sheet and insert it in an existing Access table. I'd like to do this strictly through VB rather than start an instance of Access and use the function. Any pointers? Thanks,

Missing Excel Data I am reading Excel Data into a Dataset in VB.net using the following code: Dim MyDataset as New Dataset() Dim strConn As String = Data Extended 8.0;HDR=YES'" Dim mySingleData