Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Import/Append with Memo
Message
From
18/11/2008 11:28:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Excel Import/Append with Memo
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01362569
Message ID:
01362569
Views:
65
Hey all!

I have an Excel file that I can get into a standalone table with this:
IMPORT from "E:\src\sampleproducts_20081113.xls" TYPE XLS
One column in the resulting table, when a row value is > 255 characters, comes through empty.

So I then tried this:
ZAP
MODIFY STRUCTURE (changed the problem column from "char" to "memo)
APPEND FROM "E:\src\sampleproducts_20081113.xls" TYPE XLS
BROWSE last
And some row values that that column are still empty, although they are now Memo column/field type.

Opening the file in Excel 2007 shows all of the data fine, but of course I need to do this with VFP.

All suggestions appreciated.

Thanks!
Next
Reply
Map
View

Click here to load this message in the networking platform