Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbf to Excel
Message
 
To
24/07/2007 09:53:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01243144
Message ID:
01243147
Views:
23
Try: COPY TO type xl5

HTH

>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
Speak using soft and sweet words in case you have to eat them later.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform