I've been trying to import .DBF files into Access 2000 - I have no problems until I get to Memo fields. These Memo fields seem to longer than the importing capability. Some of the Memo's are extremely huge. The only way that I've been able to maintain integrity of the field is to export them into an Excel spreadsheet, however, I haven't had the opportunity to try and import via the Excel spreadsheet. Has anyone else had the experience with this? Please advise if so - any help would be MUCH appreciated.
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
.DBF Memos
- Thread starter BanditLV
- Start date
FoxProProgrammer
Programmer
A memo field in Access is limited to 65,535 characters. In FoxPro, a memo field was only limited by the size of your hard drive. The difference, I believe, is in the way the software stores your data. In FoxPro, memos are stored in a separate file with a .fpt extension, so the size of the field is limited by how much space you have on your storage device. Since FoxPro databases can reside on a network drive, developers used them to store a lot of information since the constraints were limited. The only workaround that I can think of is to break the large memo fields up into several smaller memo fields in Access and concatenate the information when it needs to be displayed. Good luck!
dz
dz
- Thread starter
- #3
Well, in all actuality, the databases I'm converting are in Alpha, which uses the same theories as FoxPro and Paradox when it comes to database management. I'll look into the documentation in regards to the size of the Memo fields and if they're kept in a different file.
Thanks for the heads-up and, concurrently, the headache...
Thanks for the heads-up and, concurrently, the headache...
- Status