on 10-07-2008 10:14 AM
Hi All,
how do we export data from Sap B1 to a excel sheet through code
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try clicking on the menu ID 7169 by code.
Vasu Natari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michael,
i posted a code to access excel cells in this
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.