PDA

Click to See Complete Forum and Search --> : mdb to mysql

ripken204
03-09-2007, 06:40 PM
how would i accomplish this with php? i know that there are programs out there but i would like avoid having to use that step. i just want to be asble to upload the mdb file, and have the php do its job putting it into a mysql db.
NightShift58
03-09-2007, 06:51 PM
It would be nice...
ripken204
03-09-2007, 06:58 PM
so its not possible?
NightShift58
03-09-2007, 10:39 PM
There's no built-in ability on the part of PHP to just read an Access file and convert it to MySQL. You'll need a toolkit for that and it won't be quite like what you wanted, but it'll work.

Take a look at:
http://www.mysql.com/products/tools/migration-toolkit/tutorials/AccessMigrationTutorial.html

You can get the toolkit here:
http://www.mysql.com/products/tools/migration-toolkit/
Nanscombe
03-10-2007, 02:05 PM
Hi Rripken204,

It would depend on what you want to do?

Data only?

1) Create an ODBC link to your MySQL Database.
2) Open MS Access.
3) Select an Access table.
4) File -> Save As/Export to (File Type) ODBC Database.

Forms, Reports and Macros? Not trivial. I don't even know if its possible.

Regards
Nigel
ripken204
03-10-2007, 03:40 PM
thats okay. im not actually using access, but a program that stores its data in an access database. the program can convert to csv so ill just use that. i would just like it if i didnt have to convert it each time i wanted to import it to mysql.
mynetworksolut
03-10-2007, 03:59 PM
I show you the fastest way without any coding.

First, export all tables in mdb to .txt format because there's no built-in function to transfer between Microsoft and Web php engine.
Download phpMySQL as an interface to interact with MySQL, create a database and tables, then select "Import" to import all the .txt files into those tables.

= = = = = = = = = = = = = = = =
Technical Consulting Company
http://www.mynetworksolution.com
Web developer
Nanscombe
03-10-2007, 04:24 PM
Hi ripken204,

There was a similar thread recently about loading csv files to a database using PHP, which can be found at: http://www.webdeveloper.com/forum/showthread.php?t=140960

It may hold some useful info.

SQLyog, a free MySQl GUI, also has an import CSV function.

Regards
Nigel
NightShift58
03-10-2007, 06:22 PM
There was a similar thread recently about loading csv files...Thanks for the plug but I don't think that this is really an option for the OP.

It's one thing to have an Excel .CSV and import that blindly, but an Access .mdb might hold more secrets than meets the eye...

The toolkit provided by MySQL would be ideal if the OP has to this on a recurring basis.

Take a look at:
http://www.mysql.com/products/tools/...nTutorial.html

You can get the toolkit here:
http://www.mysql.com/products/tools/migration-toolkit/
NightShift58
03-10-2007, 06:23 PM
I show you the fastest way without any coding.Where's the "fast" part?
ripken204
03-10-2007, 06:44 PM
i was the latest thread about the csv files, which works perfectly.

so ill just use csv instead of mdb. the program can export to csv so its not like theres an inconvenience there.