cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting to Excel Sheet

Former Member
0 Kudos

Hi All,

how do we export data from Sap B1 to a excel sheet through code

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

You can either use the following method,

1.) Create a VBA macro to query the record out from SAP data,

2.) Create an ODBC connection, and go to Excel, Data menu, Import External Data, New database query, and select the ODBC connection that you created in Control Panel. Then either use Store Procedure or just SQL statement to process your data retrieval.

Regards,

cks

Former Member
0 Kudos

Hi,

Try clicking on the menu ID 7169 by code.

Vasu Natari.

Nussi
Active Contributor
0 Kudos

Hi Michael,

i posted a code to access excel cells in this

[Thread|;

it was used for import but you get all the info you need there.

create a excel object and access a cell.

btw - the simpliest way is to export the data to

a .csv file -> ist just a textfile where the data is split with ;

when you open this .csv in excel it looks like it's an excel

lg David