access db to mysql db table?

B

Brez

Access db file (22 Mb-list), i need to upload it to my SQL database as a table.
Is this possible?
 
G

golfinray

No, a link does not create a table. It just gives you access to one in
another database.
 
J

John W. Vinson

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.
 
D

David W. Fenton

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.
 
A

Albert D. Kallal

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
ODBC Connector to MySQL server 2
How to use OLE DB in Access 2007? 5
Access tables to MYSQL 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Get internet leads into main DB 1
How Easy To Convert Access > MySQL? 13
Retrieving a value from a table 1

Top