Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import / Export memo data to Excel or ASCII
- Thread starter RichardH
- Start date
1. I doubt if your are using some older foxpro version. Couls you please specify which version you are using.
2. If you are importing from DB4, OPEN THE TABLE in foxpro and when the question asked convert memo field ... say YES and then proceed.
Hope this helps.
Ramani
2. If you are importing from DB4, OPEN THE TABLE in foxpro and when the question asked convert memo field ... say YES and then proceed.
Hope this helps.
Ramani
- Thread starter
- #3
I am using Visual Foxpro 6.0. The problem is not importing data from dbase (DB4) files, that works great. The problem is importing from Excel or ASCII. The commands would be:
USE myfile
APPEND FROM spreadsheet.xls TYPE XL5
or
USE myfile
APPEND FROM text.txt TYPE DELIMITED
In which case the memo fields are ignored. The same is true with the IMPORT command or when exporting data with the COPY TO or EXPORT commands.
USE myfile
APPEND FROM spreadsheet.xls TYPE XL5
or
USE myfile
APPEND FROM text.txt TYPE DELIMITED
In which case the memo fields are ignored. The same is true with the IMPORT command or when exporting data with the COPY TO or EXPORT commands.
Richard,
While I couldn't find anything specific in the Help file about this, I guess it makes sense. Memo fields are kind of a special beast, and copying/exporting them, would violate/not make sense for some of the formats in a general sense. (Can you imagine a 1MB comma delimited field? Excel cells certainly can't be that large.) For importing/appending you could always use low-level IO for some file types and other multi-step techniques for other specific situations.
For a generic situation consider using a 3rd party solution like Data Junction to preprocess the data.
Rick
While I couldn't find anything specific in the Help file about this, I guess it makes sense. Memo fields are kind of a special beast, and copying/exporting them, would violate/not make sense for some of the formats in a general sense. (Can you imagine a 1MB comma delimited field? Excel cells certainly can't be that large.) For importing/appending you could always use low-level IO for some file types and other multi-step techniques for other specific situations.
For a generic situation consider using a 3rd party solution like Data Junction to preprocess the data.
Rick
See:
HOWTO: Append Records from Any Delimited File with Memo Data
Jon Hawkins
The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed
HOWTO: Append Records from Any Delimited File with Memo Data
Jon Hawkins
The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed
- Status