FAQ: Access and MySQL

[Remou]

Access Version: 2000

You can insert data from Access into MySQL using DSN.

You will need:

DSN=Suitable system DSN for MySQL

Then, depending on your set-up, you can incude:
Database=MySQLDatabaseName;
Trusted_Connection=Yes;

vbLine number Off | Hide | Select all

1. Set db = CurrentDb
2. strSQL = "Insert INTO [ODBC;DSN=DSNName;].NameOfMySQLTable " _
3. & "Select AnyField As NameOfMySQLField FROM AnyAccessTable;"
4.  
5. db.Execute strSQL, dbFailOnError
6. End Sub

I have not been playing around with this very long, but as far as I can tell, you must have matching field names, however, you can use aliases to make the names match.

[Emtucifor]

DNS <> DSN

[Remou]

I though dyslexia was one of the few problems I had avoided. Oh well, you are never to old to forget.

[Emtucifor]

I really thought you meant you could use DNS somehow.