Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dbf to Excel
Message
 
À
24/07/2007 09:53:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
01243144
Message ID:
01243147
Vues:
25
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform