Converting Foxpro 2.6 Database to Access 97 database

[chrisfricke]

Does anyone know an easier way of doing this than going through each table in the tabledefs and each record in the table and each field in the record!?!
If you do, please be aware that this is a very badly designed database and it has no end of field and table names which are reserved in SQL which causes some major problems. Also it is not possible to rewrite the database as I have to copy the data as well from several different foxpro databases to indervidual access databases

Cheers

Chris

[JHausmann]

Use Access to import the table.

[chrisfricke]

Unfortunatly this has got to be used on computers which do not have Access 97 installed - Sorry!

[JHausmann]

Well then, your management has a decision to make. You can write a program that has the functionality you want or they can buy ONE copy of Access. It's usually cheaper to do the latter.

The one machine with Access installed can obtain a copy of all of the FoxBase databases and convert them in that one location. Upon completion, the .mdf's are sent to their respective owners.

[This message has been edited by JHausmann (edited 08-27-1999).]