General discussion

Locked

Convert a Foxpro database to Excel

By hungleq ·
How do I do it?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Convert a Foxpro database to Excel

by DKlippert In reply to Convert a Foxpro database ...

From the Excel help file:

Set up a data source that uses the Microsoft dBASE or FoxPro driver

Before proceeding with these steps, it's a good idea to place all of the database files that you want to use in the same folder so that Query can find all of your files and you don't have to type the full path whenever you want to add a table to a query. If you want, you can place the database files in one folder and the index files in another folder.

1.If the Create New Data Source dialog box is not displayed, point to Get External Data on the Data menu, click New Database Query, click the Databases tab, and then double-click New Data Source. Type a name for the data source in step 1, and then click Microsoft dBase Driver or Microsoft Visual FoxPro Driver in step 2.

2.In step 3, click Connect.

3.Do one of the following:
For the Microsoft dBase Driver, click the version of dBASE or FoxPro that was used to create your database files in the Version list. If the database files are not in the current folder, clear the Use current directory check box, and then click Select Directory to locate the folder.
For the Microsoft Visual FoxPro Driver, click the option for your FoxPro database under Database type, and then enter the path to the database in the Path box.

4.If the index files for the database are also in a different folder, click Select Indexes to locate the folder.

Collapse -

Convert a Foxpro database to Excel

by hungleq In reply to Convert a Foxpro database ...

The question was auto-closed by TechRepublic

Collapse -

Convert a Foxpro database to Excel

by isys In reply to Convert a Foxpro database ...

Start Excel, select File, Open, and for File Type select dBase; then navigate to your file. Be sure you have a backup copy before starting out.

Collapse -

Convert a Foxpro database to Excel

by hungleq In reply to Convert a Foxpro database ...

The question was auto-closed by TechRepublic

Collapse -

Convert a Foxpro database to Excel

by hungleq In reply to Convert a Foxpro database ...

This question was auto closed due to inactivity

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums