Extracting Data from a .mdb file to mysql database using php

Question

Possible Duplicate:
Access from PHP to .mdb file on Ubuntu

Hi I'm developing a webstore using the php framework yii..

I want to upload a .mdb file to our system, and extract data from it and insert into mysql database..

Is there anyway of doin this?

It'll be great if someone could help me out.

Thanks

check here: http://devzone.zend.com/1315/reading-access-databases-with-php-and-pecl/ — , May 22 '12 at 07:19
check http://stackoverflow.com/questions/5722544/how-can-i-convert-an-mdb-access-file-to-mysql-or-plain-sql-file — Dolly, May 22 '12 at 07:20
@cutebabs I think those are manual tools, and OP is looking for something that can be automated — eis, May 22 '12 at 07:23

score 6 · Answer 1 · 2012-05-22T08:20:21.200

6

Use odbc_connect() function using a database source name (DSN). Alternatively, a DSN-less connection string can be used.

DSN-less connections

if no password, leave username as "sa" and password blank.

$conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdb_file", $user, $password);

To Connect with DSN

from *http://www.w3schools.com/php/php_db_odbc.asp*

Open the Administrative Tools icon in your Control Panel Double-click on the Data Sources (ODBC) icon inside. Choose the System DSN tab. Click on Add in the System DSN tab. Select the Microsoft Access Driver. Click Finish. In the next screen, click Select to locate the database. Give the database a Data Source Name (DSN). Click OK.

$conn = odbc_connect($dsn_name, $user, $password);

Query:

$res = odbc_exec($conn, "select * from table");

List results:

while( $row = odbc_fetch_array($res) ) { 
    print_r($row); 
}

More info: http://www.php.net/manual/en/ref.uodbc.php

edited May 22 '12 at 08:20

answered May 22 '12 at 07:26

k..but can i do this after uploading the file and initializing it to $mdb_file ?? – era May 22 '12 at 07:34
1

Yes, it should work fine. Let me know. – May 22 '12 at 07:35
thanks i will try it and let u know ... – era May 22 '12 at 07:36
okay i tried what you suggested and its giving a sql error saying SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect do i need to import anything in order to use the odbc functions? – era May 22 '12 at 07:54
Are you running the code on a windows machine? – May 22 '12 at 07:58
yes i am and im using a php framework called yii – era May 22 '12 at 08:00
any idea why im getting that error? – era May 22 '12 at 08:11
I edited my answer, check above. Use a DSN – May 22 '12 at 08:14

score 0 · Answer 2 · answered May 22 '12 at 07:19

0

read the data from mdb to csv

read from csv and insert into mysql

answered May 22 '12 at 07:19

Satya

8,693
5
34
55

like the answer if this helps – Satya May 22 '12 at 07:23
is there a way of converting the .mdb file to .csv using yii or php? – era May 22 '12 at 07:27

Extracting Data from a .mdb file to mysql database using php

2 Answers2