Mysql & Ms Access
Mysql & Ms Access
Is there someone who can help me to transfer a MS Access database into a Mysql database?
Greetz,
Dave
Greetz,
Dave
That looks like very serious talk for a café, Dave ![Smile :)](./images/smilies/icon_e_smile.gif)
... but I'm not very helpful, am I?![Crying or Very Sad :cry:](./images/smilies/icon_cry.gif)
![Smile :)](./images/smilies/icon_e_smile.gif)
... but I'm not very helpful, am I?
![Crying or Very Sad :cry:](./images/smilies/icon_cry.gif)
Last edited by sn26567 on 30 Jul 2003, 08:48, edited 1 time in total.
André
ex Sabena #26567
ex Sabena #26567
Ebos,EBOS wrote:What is Mysql ???
Greetz,
EBOS
MysQL is a database language, wide spread used on the internet... to learn more: http://www.mysql.com/ , or http://www.phpfreakz.nl/
It works very well with PHP... and this site is also running on PHP & MySQL. (and some parts of mine site also runs with them)
Hope this helps a bit
TOM
hmmmm....
It's not a language, it's a database
the database uses the query language SQL ....
Never say language to a database !
in Access:
Select the table or query you want to export and click Export... from the File menu. In the dialog box that will appear choose the location where you want to save your export file, the file name, and choose Text Files in the Save as type: drop-down list. Click the Save button to bring up the Export Text Wizard. Click the Next button and make sure the delimiter is Comma and the Text Qualifier is ". Click Next and verify the file path and name, then click Finish
create the database structure in MySQL watch out for correct datatypes..
and then execute the following SQL statement:
LOAD DATA LOCAL INFILE 'export_file.txt' INTO TABLE table_name;
voila
Flip
It's not a language, it's a database
the database uses the query language SQL ....
Never say language to a database !
![Twisted Evil :twisted:](./images/smilies/icon_twisted.gif)
in Access:
Select the table or query you want to export and click Export... from the File menu. In the dialog box that will appear choose the location where you want to save your export file, the file name, and choose Text Files in the Save as type: drop-down list. Click the Save button to bring up the Export Text Wizard. Click the Next button and make sure the delimiter is Comma and the Text Qualifier is ". Click Next and verify the file path and name, then click Finish
create the database structure in MySQL watch out for correct datatypes..
and then execute the following SQL statement:
LOAD DATA LOCAL INFILE 'export_file.txt' INTO TABLE table_name;
voila
Flip
Flip Thx,
André,
It is serious talk for a café, but it is necessary for the website. I am trying to build a real database for the aircraft registrations, not just a graphical version like it now is. An therefore I wanted to use Mysql, but the current register is in an Access file on my pc and if I can convert the Access file to a Mysql, I do not need to input the data another time. There are now +/- 473 aircrafts in my register so that would be a hell of a job.
Greetz,
Dave
André,
It is serious talk for a café, but it is necessary for the website. I am trying to build a real database for the aircraft registrations, not just a graphical version like it now is. An therefore I wanted to use Mysql, but the current register is in an Access file on my pc and if I can convert the Access file to a Mysql, I do not need to input the data another time. There are now +/- 473 aircrafts in my register so that would be a hell of a job.
Greetz,
Dave
Dave,liebensd wrote:André,
It is serious talk for a café, but it is necessary for the website. I am trying to build a real database for the aircraft registrations, not just a graphical version like it now is.
Great! When you're finished, I'll invite you for a drink at the Luchtzak pub!
![Wink :wink:](./images/smilies/icon_e_wink.gif)
André
ex Sabena #26567
ex Sabena #26567