Cannot use data from FoxPro database tables
Article ID: 137 - Updated: Sep 2, 2009 - Products: All products - Version: Any - Category: License and Activation
Databases created in FoxPro (with file extension .DBF) are not natively supported in NiceLabel software. There is no database driver provided for connection to such data in NiceLabel installation. If you need to link to FoxPro databases there are two solutions available for you. Use one of the following solutions.
Solution 1 (recommended)
To connect to FoxPro databases and obtain the data out of them the appropriate ODBC driver must be installed on the system. You must create the Data Source Name (DSN) in ODBC Data Source Administrator. This utility is located inside Administrative Tools in Control Panel. Then use this DNS as the ODBC source in NiceLabel software.
If you do not have the ODBC driver for FoxPro installed on the system, you can use a different approach. You can convert the FoxPro database to some other database format for which the driver is available. It can be done like this.
- Start Microsoft Excel application. Open the FoxPro database. Just use the Open command in the File menu. The data from FoxPro table will be displayed in the spreadsheet.
- Select the command Save As from the File menu and save the database in the .dbf (dBase) file format.
- Start NiceLabel software and use the database wizard to link to the converted database. The driver for dBase table access are installed with NiceLabel software.