تحويل البيانات الى اكسل
تاريخ المشاركة 19 October 2004 - 12:37 PM
open access file and make like table or query using ODBC
open the table or qury(based on Oracle u can take the statment from oracle report and put it on access query) from access then
open file --> export to Xls files
Eng. Khalil Sakr
تم التعديل بواسطة sakr_orcl, 20 October 2004 - 11:49 AM.
وقل ربي زدني علما.
من عمل بما علم أورثة الله علم ما لم يعلم
تاريخ المشاركة 21 October 2004 - 11:59 AM
if you are running your report through the web woth an html format you can save the html file the open it using the excel with specifing the column specification
the best solution for generating the report directly to excel is to use the ole object to speak directly from the forms through code to the excel so as to be able to control the format
also there are some programs on the net that generate the reports to excel either they were run on the web or from the client environment (rep2excel )