Basically this task is pretty easy when you think about it... but i found no Answers in Microsoft Access or MSDN. I have to create a connection to an new Database and query the old one. After validating the old data, everything is written in a new fine Form to the my new Database.
Any Ideas?
Add: Old Database is an Firebird Database. This Data needs to be new structured and migrated to an new MySQL Database.
If no binary data in your database, I'd suggest just doing a csv export and reimporting.
if you can access the firebird database via ODBC, i suggest the mysql migration toolkit.
You can use a tool like database workbench.
Why you want to migrate to MySQL ?
You'll need to create the schema separately in MySQL but it's not difficult, there are lots of tutorials, and you can probably find a Firebird tool to export the DDL into a script that will either just work, or be easy to modify.
If you want to use Access in the middle, just attach each of the two external databases from Access (using ODBC or your choice of drivers). You can use the query designer wizards to build a INSERT INTO ... FROM ... type query as you would for any other situation.