Bill
|
| Posted: 08/28/2002, 7:25 AM |
|
Hi,
I have a Access database that I want to upload onto a server running SQL.
Does anyone know an easy way to do this?
I just want to get the database tables accross, Im not worried about any quirys, forms and so on.
|
|
|
 |
Simon
|
| Posted: 08/28/2002, 7:31 AM |
|
I have been using this with good results. And the first 30 runs are free, before you have to register. :)
http://www.dmsofttech.com/downloads.html
|
|
|
|
xpo
|
| Posted: 08/28/2002, 4:14 PM |
|
http://www.intranet2internet.com/
access dump
|
|
|
|
Nicole
|
| Posted: 08/29/2002, 2:44 AM |
|
Bill,
you can convert Access dbs to MySQL db in some ways:
1. Use DBTools from http://dbtools.vila.bol.com.br
It supposedly allows for easy management of MySQL database, as well as
export from MS Access to MySQL.
2. You can try using MySQL Front, available at http://www.anse.de/mysqlfront/ , which makes it easier to work with MySQL.
3. You can also use Export to ODBC datasource feature in MS Access ,
this way you can export Access tables to db represented by a given
datasource.
|
|
|
|
Bill
|
| Posted: 08/29/2002, 6:29 PM |
|
I ended up using Accessdump.
I tried the DMsofttech software but for some reason could not get it to connect to the MySQL server I was using.
AccessDump was easy to use but I did have to edit a couple of lines in the dumpfile. AccessDump likes to drop then recreate the database. Both servers I have access to dont allow that. I just deleted the line with drop in it at the top.
All worked fine after that.
Thanks to all who replyed.
|
|
|
|
kangus
|
| Posted: 09/01/2002, 1:50 AM |
|
MyAccess is an Add-In for Microsoft Access that allows the user to manage MySQL Databases from inside MS-Access.
Version 1.5 can be used with Access2000 and AccessXP
If you’re using Access97 you have to use MyAccess Version 1.4 which is available for both Access97 and Access2000/XP
Main Features of MyAccess 1.5 are:
· Create/Modify/Open Tables
· Create/Modify/Open Queries (queries are stored locally on your PC)
· Import/Export Tables from Access to MySQL
· Synchronize tables between Access and MySQL
· Log changes made using MyAccess
So from Access you click Tools : Addins then MyAccess and you open a mySQL database, check the access tables you want copied into mySQL and click ok, your done (unless someone forgot to add a premary key to a table).
Between myAdmin and MyAcess moving information between the Access and my SQL is a snap.
|
|
|
|
|
