Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IMPORT .XLS to Memo fields in .DBF
Message
 
À
01/12/2003 13:26:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00854759
Message ID:
00854763
Vues:
18
Try something similar to this:
LcFlSrcXls="c:\book1.xls"
import from (LcFlSrcXls) xls

alter table book1 alter column (field(1)) M

oleapp = CREATEOBJECT("Excel.Application")
OleApp.DisplayAlerts = .f.
=oleapp.Workbooks.Open(LcFlSrcXls)

sele book1
iscan=0
scan
	iscan=iscan+1
	replace (field(1)) with oleapp.ActiveSheet.Range("A"+alltr(str(iscan))).Text
endscan

oleapp.Workbooks.Close
OleApp.Quit
RELEASE oleapp
>How do I handle import of Excel (.XLS) column data to
>.DBF Memo fields. Now when I execute APPEND FROM Type .XLS,
>all fields come into .DBF record field data, except for
>Memo-type fields in .DBF.
>
>How do I get this data from .XLS into .DBF table file?
>
>DBK
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform