Software

Ask something
Discussion Locked

Pack FoxPro with Access

0 helpful
7 replies

by khart

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to delete a Foxpro Database table through Access 97/2000. Someone told me to PACK the records when I do this, however I do not know how to PACK a FoxPro database through Access. Is this a VB function? I can select and delete records in the FoxPro table, but I cannot remove the records because FoxPro flags the records and keeps them in case of an accidental deletion. I need to be able to just wipe the table out and remove all records with a command. I've heard it is the PACK command but I do not know how to use this. Thanks.

7 replies

by bunkee

1. Open a database.

2. On the File -> Get External Data -> Import.

3. Select the drive and folder where the .dbf files are located, 2x click its icon.
NOTE: In the Files of Type: text box, use FoxPro if it is an option, if not, use dBase
4. Follow the prompts.

Do this for each .dbf file you want to import.

If you need more information, go to Access Help and type: Import or link dBASE files

Once you have completed the conversion, you will have not have to do anything elseto the tables. That does not mean any of the forms or reports (objects) will be converted. This will only get you the tables and their associated data. Good Luck and let me know how it went!

by bunkee

1. Open a database.

2. On the File -> Get External Data -> Import.

3. Select the drive and folder where the .dbf files are located, 2x click its icon.
NOTE: In the Files of Type: text box, use FoxPro if it is an option, if not, use dBase
4. Follow the prompts.

Do this for each .dbf file you want to import.

If you need more information, go to Access Help and type: Import or link dBASE files

Once you have completed the conversion, you will have not have to do anything elseto the tables. That does not mean any of the forms or reports (objects) will be converted. This will only get you the tables and their associated data. Good Luck and let me know how it went!

by chainsawz

I use the FoxPro command 'zap' to wipe out all the records in an open table. Also,'erase tablename.dbf' is great for deleting the whole table.

If you are having trouble getting these commands to work from Access, you might try creating a programin FoxPro containing the zap or erase command, and then running the .prg from an Access macro.

Good luck!

This discussion is closed to new replies.