PDA

View Full Version : Appending from XLS into a MEMO field


jslcomp
11-27-06, 16:16
I believe that this should be a relatively easy fix.
I'm trying to append from an XLS file with one of the columns going into a memo field. When I try this, the Memo field keeps coming up empty. I didn't use the IMPORT command because I have the structure of the table exactly the way it is needed and I don't want to keep modifying it due to the import.

Thanks.

loquin
11-30-06, 15:02
What type of database? dBase? Foxpro?

jslcomp
12-01-06, 11:01
I'm trying to do the import into a FoxPro table. I can do it through the Import Wizard setting the field type to Memo. However, once the table gets created, I need to modify the structure to include additional fields. I tried to create the table in the format I need and then do the import, but VFP 7 APPEND FROM doesn't put the data into the MEMO field.

:confused:

zlatan24
06-06-08, 15:46
For work with excel files,use next application-fix xls (http://www.recoverytoolbox.com/fix_xlsx.html),can proceed with analysis of damaged file and fix .xls,see the results in a preview window and fix corrupted xlsx files,your recovered data is not formatted,you can only preview your document, not fix corrupted xlsx,will save many hours of your work and help to fix corrupted xlsx files,restore data such as HDD corruption, download errors, viruses, hardware failure, that can lead to Excel file corruption.