Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing data from excel to a memo field
Message
 
To
21/09/2005 15:28:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01051756
Message ID:
01051919
Views:
7
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform