Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbf to Excel
Message
From
24/07/2007 09:53:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Dbf to Excel
Miscellaneous
Thread ID:
01243144
Message ID:
01243144
Views:
56
Dear Experts
set century on

lcfullpath = fullpath(curdir())
lcfullpath = left(lcfullpath, len(lcfullpath) - 1)
lclastfolder = justfname(lcfullpath)

abc=alltrim("E:\SoftBkup\"+lclastfolder+alltrim("\")+alltrim("Xls")+alltrim("\"))
ab4=alltrim(abc)+alltrim(dtos(date()))

mdbcname=(sys(5)+alltrim(sys(2003)))+'\TABLES\ACWS.dbc'
#define crlf chr(13)+chr(10)

close all
close data
open database (mdbcname) excl
= adbobjects(latablearray, "TABLE") && Put table names into an array
for i=1 to alen(latablearray) 	&& loop through each table in the array
	mtablename=latablearray(i) 	&& pick up table name from array

	x=0
	on error x=error()
	use (mtablename) in 0 	&& attempt to open table
	on error

	if x=0 			&& Possible table corruption
		copy to type xl5
	endif
next x
The codes copy all dbf files to present directory.
But I want to copy all dbf files with their orinal names to following location
ab4
How to modify path in this line

copy to type xl5

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform