Y Y
asked on
Import Foxpro table to Excel
We have a 15~20 yrs old app coded by Clipper with Foxpro (v2.x, i guess) as the backend DB.
We are trying to import the tables to Excel for reporting and found two problems as below
1. If the table has a "memo" column, it will not be imported.
Here is one example:
CONT.DBF
CONT.DBT
CONT.FPT
The above table "CONT.DBF" has a memo column, which is actually in a totally separate file "CONT.FPT"
This table cannot be imported.
Here is another example:
SALESSUMM.DBF
This table does not have a "memo" field, and it does not have a .FPT file associated with it, so we can import it to Excel successfully.
2. When creating a data source in Excel, we are not able to use Foxpro driver (Microsoft dBase VFP Driver (*.dbf)), we have to choose "Microsoft dBase Driver (*.dbf)".
I tried on Excel 2003, my colleague tried Excel 2010 which has the same problem. He also did some research, and told me that we might need IASM driver which we do not know to download.
Any thoughts?
Thanks
We are trying to import the tables to Excel for reporting and found two problems as below
1. If the table has a "memo" column, it will not be imported.
Here is one example:
CONT.DBF
CONT.DBT
CONT.FPT
The above table "CONT.DBF" has a memo column, which is actually in a totally separate file "CONT.FPT"
This table cannot be imported.
Here is another example:
SALESSUMM.DBF
This table does not have a "memo" field, and it does not have a .FPT file associated with it, so we can import it to Excel successfully.
2. When creating a data source in Excel, we are not able to use Foxpro driver (Microsoft dBase VFP Driver (*.dbf)), we have to choose "Microsoft dBase Driver (*.dbf)".
I tried on Excel 2003, my colleague tried Excel 2010 which has the same problem. He also did some research, and told me that we might need IASM driver which we do not know to download.
Any thoughts?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you have a copy of Foxpro or Visual Foxpro?
If so, you can write a small program to convert the data from the DBF data table into a format which Excel can utilize and it can be done so as to include the Memo field data.
You might be interested in looking over the previous posting
https://www.experts-exchange.com/questions/27815222/How-to-export-data-from-Visual-FoxPro-9-that-includes-a-'memo'-data-type.html
If you do not have a copy of Foxpro/Visual Foxpro, you might want to look at commercial data conversion products like: http://dbconvert.com/ or others.
Good Luck