Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert many tables to excel sheets
Message
From
29/12/2004 06:59:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Convert many tables to excel sheets
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
00972888
Message ID:
00972888
Views:
54
hi all,
i need help with this code under,to let all tables i have it,convert it to excel sheets as under
CLOSE all
USE aaa
use bbb
use ccc
use ddd....etc..

*INDEX ON flag tag FLAG_TAG
gcDelimName = ALIAS( ) + '.xls'
gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
IF EMPTY(gcDelimFile)  && Esc pressed
   CANCEL
ENDIF
COPY TO (gcDelimFile) xls  && Create delimited file
MODIFY FILE (gcDelimFile) NOEDIT
endif
Next
Reply
Map
View

Click here to load this message in the networking platform