Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
conversion from access to mySQL 1
- Thread starter missippi
- Start date
-
1
- #2
Do a data export from access for each table into scv format and import each into mysql after recreating the tables.
I'm not aware of any magic ways to suddenly change from one to the other, sorry. ***************************************
Party on, dudes!
![[cannon]](/data/assets/smilies/cannon.gif "[cannon] [cannon]")
I'm not aware of any magic ways to suddenly change from one to the other, sorry. ***************************************
Party on, dudes!
Hello,
Why don't you use MS-Access to connect to your remote
mysql database in order to update it "on-the-fly"?
You only have to install the odbc drivers and configure
it. Ask me if you need help for the configuration.
Have a good day.
Why don't you use MS-Access to connect to your remote
mysql database in order to update it "on-the-fly"?
You only have to install the odbc drivers and configure
it. Ask me if you need help for the configuration.
Have a good day.
- Thread starter
- #4
That's very simple:
1) Download the ODBC drivers from microsoft.
2) Install it.
3) Open it by accessing it via the control panel.
4) Click on the tab called System DSN
5) Button Add
6) Choose mysql in the list of drivers and continue.
7) Type a name (same as a bookmark) for this connection
in "Windows DSN name"
8) Fill host/IP
9) Enter the database you want to access to in "database name"
10) user & password.
11) Click OK and leave.
12) Open MS-ACCESS
13) Choose "ODBC database" in the open menu.
14) Click on the tab called "Machine Data Source"
15) Select your "data source name" and click OK.
16) Choose the table you want to edit.
DONE!
Bye
1) Download the ODBC drivers from microsoft.
2) Install it.
3) Open it by accessing it via the control panel.
4) Click on the tab called System DSN
5) Button Add
6) Choose mysql in the list of drivers and continue.
7) Type a name (same as a bookmark) for this connection
in "Windows DSN name"
8) Fill host/IP
9) Enter the database you want to access to in "database name"
10) user & password.
11) Click OK and leave.
12) Open MS-ACCESS
13) Choose "ODBC database" in the open menu.
14) Click on the tab called "Machine Data Source"
15) Select your "data source name" and click OK.
16) Choose the table you want to edit.
DONE!
Bye
I've never tried to create tables with ms-access.
I always use it to edit data and to paste new
records coming from excel files.
BTW, when pasting rows in access, be careful
the table has the right NULL/NOT NULL settings.
Otherwise you will get plenty of error messages
if you excel table has empty cells.
I always use it to edit data and to paste new
records coming from excel files.
BTW, when pasting rows in access, be careful
the table has the right NULL/NOT NULL settings.
Otherwise you will get plenty of error messages
if you excel table has empty cells.
- Thread starter
- #8
I think it is there:
The name has changed I guess. It's not called
ODBC 2.5 anymore.
Good luck (such a mess in this page...).
The name has changed I guess. It's not called
ODBC 2.5 anymore.
Good luck (such a mess in this page...).
- Status