In message <41**********************@news.newsgroups.ws>, Konrad Sz
<ko***@eranet.pl> writes
Actually I've forgotten that conversion from Ms Access is also one that
I'd like know, so is the place getting a bit relevant now??
Sorry for that mistake. Next time I'll try to be more careful ;).
Moving data from one back-end database to another is relatively simple.
Create a new database and new tables with the right fields. Use ODBC to
create linked tables in Access then use append queries to append data
from the old table to the new one.
That might not be the most efficient way of moving data across but it is
probably the simplest.
If you have forms or reports in Access you can continue to use those,
they can use the data stored in MySQL or PostgreSQL databases.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.