|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I have a Database file or a table in MS Access, now I wanted to convert that into MySQL. Also I have these record in a text file. Can I get that records into mysql.
Please help me as I am using MySQL/PHP for the first time.. |
|
#2
|
|||
|
|||
|
Hi,
I haven't yet converted an Access DB to MySQL, but if you have a textfile you could simply use the MySQL command: LOAD DATA INFILE 'filename goes here' INTO TABLE 'tablename'; Read the MySQL manual for further instructions on how to use LOAD DATA INFILE. |
|
#3
|
|||
|
|||
|
You could also look at the Converters section in: http://www.mysql.com/Contrib/
I've seen some Access --> MySQL converters. As I mentioned before, I've never done it, but if it worked for you, maybe you could explain how you did it? |
|
#4
|
|||
|
|||
|
Thanks for your reply.
I suppose It will provide me great help in future as I have already done that by first converting access database to text file and then using command importsql I have converted it into MySQL table. I will try this also and whenever I complete this I will let you know. thanks again [This message has been edited by sanveer (edited April 22, 2000).] |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Converting Access database or a text file into mysql |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|