Re: Export/Import Database - Help??

hi, > exporting databases This is easy you can use dbexport & dbimport see appendix to tech manuals or you can use some sql on the systemables to write sql statements with a load or unlaod for each table. If your still stuck try select "unload to ",tabname," select * from ",tabname," ; " from systables where tabtype =`"T" and tabid > 99 and the same with the first line of select " load from ",tabname," insert into ",tabname," ;" use these commands in dbaccess or sql to create an output file called load.sql and unload.sql then run these command files. G.K. Twaddle Technical Director Beta Computers (Europe) Ltd West of Scotland Science Park Maryhill Road Glasgow G20 OSP Scotland. tel 44-41-945-3855 beta@cix.compulink.co.uk