Page 1 of 1
mdb
Posted: Tue Jul 17, 2007 3:16 am
by aetoc
I haven't try it before and to tell you the trouth I don't know I it can be done.
I have a .mdb on my server and I would like to have access to it so I can transfer the records to the mySQL.
Have anyone done something like that (I meen the connection with the .mdb)?
Thanks in advance.
Posted: Tue Jul 17, 2007 10:33 am
by califdon
It's done all the time.
.mdb is the filetype associated with Microsoft Access. There are several tools to simplify converting data, such as at
http://www.dbconvert.com/, but if it's just a one-shot, you can simply export the .mdb data to a comma-separated-values (.csv) file from the Access menu, then import it into MySQL using the LOAD DATA INFILE command.
Posted: Tue Jul 17, 2007 5:15 pm
by aetoc
The problem is that this is something that the man that I'm building the site for will do once a month.
I would like to make it as much easyer for him. That why I'm asking.I know how to do it for the first time (csv) but He has to do it all the time.
Thanks for the reply. I'll have a look at the site you have post.