access db to mysql db table?

  • Thread starter Thread starter Brez
  • Start date Start date
B

Brez

Access db file (22 Mb-list), i need to upload it to my SQL database as a table.
Is this possible?
 
No, a link does not create a table. It just gives you access to one in
another database.
 
Access db file (22 Mb-list), i need to upload it to my SQL database as a table.
Is this possible?
Click to expand...

You'll need to create the table in SQL/Server, either using Enterprise Manager
or a SQL DDL (Data Definition Language) query (e.g. CREATE TABLE MyList...)
using a Passthrough Query. You'll need appropriate permissions on your
SQL/Server instance to be able to do so.

Once you have the table created you can (if you wish) use Access as a conduit
to migrate the data - have links to the MySQL table and to the SQL/Server
table and run an Append query.

An Access MakeTable query will create a local (JET/ACE) Access table, but I
don't believe it will let you create a SQL table.
 
An Access MakeTable query will create a local (JET/ACE) Access
table, but I don't believe it will let you create a SQL table.
Click to expand...

You can export a Jet table to an ODBC data source. This is by far
the easiest way to get Jet data tables into MySQL.
 
Brez said:
Access db file (22 Mb-list), i need to upload it to my SQL database as a
table.
Is this possible?
Click to expand...

If you install and setup the MySql odbc drivers, then you should be able to
use file->export-> from ms-access to transfer (and create) the tables in
MySql.

You could ask in some of the MySql groups as to the best approach, as they
likely often have to do this, and the people here are not likely to have
much if any knowledge about mySql.

So, the file->export option should allow you to not only export the data
from ms-access, but it should also allow you to create tables on MySql when
you do the export...
 
Back
Top