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
