|
sikharma13
Starting Member
44 Posts |
 Posted - 2013-10-29 : 03:44:25
|
| when exporting sql via fox pro to excel.. Opening export_2013-10-29-084138.xlsYou have chosen to open:export_2013-10-29-084138.xlswhich is a: Microsoft Excel 97 - 2003 Worksheetfrom: https://192.168.34.108What should Firefox do with this file?open with [Microsoft Excel (default)]save filedo this automatically for files like this from now on.like that... how to do it in VFP9??here's my query...select 'PROVINCE','MUNICIPALITY','BARANGAY','HOUSEHOLD_ID','ENTRY_ID','LASTNAME','FIRSTNAME','MIDDLENAME','EXT_NAME','NO. ELIGIBLE FOR EDUC GRANT','NO. NON-COMPLIANT FOR EDUC M1','NO. NON-COMPLIANT FOR EDUC M2','EDUC GRANT M1','EDUC GRANT M2','TOTAL EDUC GRANT','NO. NON COMPLIANT FOR DEWORMING','NO. NON COMPLIANT HEALTH CENTER VISIT M1','NO. NON COMPLIANT HEALTH CENTER VISIT M2','NO. NON COMPLIANT BIMONTHLY HEALTH CENTER VISIT','FDS NON COMPLIANT M1','FDS NON COMPLIANT M2','HEALTH GRANT M1','HEALTH GRANT M2','TOTAL HEALTH GRANT','TOTAL' union all(select province,municipality,barangay,household_id,entry_id,lastname,firstname,middlename,ext_name,no_eli_for_educ_grant,no_ncom_educ_m1,no_ncom_educ_m2,educ_grant_m1,educ_grant_m2,t_educ_grant,no_ncom_dew,no_ncom_hcv_m1,no_ncom_hcv_m2,no_ncom_bhcv,fncom_m1,fncom_m2,hg_m1,hg_m2,h_grant,total from py_abcdeehinto outfile 'd:\\data.csv'FIELDS TERMINATED BY ','OPTIONALLY ENCLOSED BY '"'LINES TERMINATED BY '\n')thanks...VFP9.0 via MySQL 5.0 |
|
Excel Automation to SQL via Visual Fox Pro