Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing data from excel to a memo field
Message
From
22/09/2005 11:30:11
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01051756
Message ID:
01052002
Views:
9
Yuri

I was able to get all the data in the memo fied by importing the data cell by cell.

Mo

>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