Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing data from excel to a memo field
Message
 
À
21/09/2005 15:28:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01051756
Message ID:
01051919
Vues:
13
Something like this:
store SQLSTRINGCONNECT(;
	"DRIVER={Microsoft Excel Driver (*.xls)};" + ;
	"FIL=Excel 97;" + ;
	"DefaultDir=c:\;" + ;
	"DBQ=c:\cim.xls");
	TO gnConnHandle
	
CURSORSETPROP("FetchMemo",.t.,0)   && set cursor properties in advance

*It is important to have " and ' inside select/update statements as  below
* field names are inherited from the first row in Excel columns

?SQLexec(gnConnHandle, 'select * from "sheet1$"')
....
>Hello
>
>is there a way to import data from Excel to a memo column (fvp8) having data more than 254 characters?
>
>Thanks
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform