SitePoint Sponsor |
|
User Tag List
Results 1 to 8 of 8
Thread: Converting MS Access to mySQL
-
Nov 20, 2000, 12:16 #1
- Join Date
- Nov 2000
- Location
- Sydney, Australia
- Posts
- 65
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Hi there,
I have created a database using Microsoft Access 2000 and I would like to convert it into a mySQL database. I have searched many places but they seem to be very vague. Can somebody please tell me in black + white how to convert?
Very much appreciated!!!
-
Nov 20, 2000, 16:10 #2
-
Nov 20, 2000, 16:15 #3
- Join Date
- Aug 2000
- Location
- San Diego, CA
- Posts
- 5,460
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Or go to http://www.mysql.com and go to the win32 downloads section and download MyAccess a freeware program that creates a MySQL database from a MS Access one for you, even does the tables
Please don't PM me with questions.
Use the forums, that is what they are here for.
-
Nov 20, 2000, 23:34 #4
- Join Date
- Nov 2000
- Location
- Sydney, Australia
- Posts
- 65
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Ok, thanks but I don't have MySQL installed on my computer, but it is on my web server.. these methods apparantly need MySQL to be installed on my own computer.
Any other suggestions?
-
Nov 20, 2000, 23:46 #5
- Join Date
- Aug 2000
- Location
- San Diego, CA
- Posts
- 5,460
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Can youconnect to your database from a remote computer, Do you have access to the 'mysql' database here you could change how one can connect to the database then you could connect from a remote computer
Please don't PM me with questions.
Use the forums, that is what they are here for.
-
Nov 20, 2000, 23:50 #6
- Join Date
- Nov 2000
- Location
- Sydney, Australia
- Posts
- 65
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yes I can connect remotely using the phpMyAdmin 2.0.1 script which is located on the web server control panel
-
Nov 21, 2000, 11:45 #7
- Join Date
- Aug 2000
- Location
- San Diego, CA
- Posts
- 5,460
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yes but that means that your script is running on the same computer as your database. You need to be able to connect with a script running on another computer.
Please don't PM me with questions.
Use the forums, that is what they are here for.
-
Nov 21, 2000, 12:28 #8
- Join Date
- Nov 2000
- Location
- Sydney, Australia
- Posts
- 65
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I mean the php script is located on the remote server.
Actually, I have figured the whole thing out now =)
Thanks for your time!!
Bookmarks