What are some common methods for transferring data from an Access database to a MySQL database using PHP?

Transferring data from an Access database to a MySQL database using PHP typically involves exporting the data from Access into a common format like CSV, then importing that CSV file into MySQL. This can be done by writing a PHP script that reads the data from the Access database, writes it to a CSV file, and then uses MySQL queries to insert the data into the MySQL database. 

// Connect to Access database
$accessDB = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/path/to/access/database.mdb");

// Query data from Access database
$accessQuery = $accessDB->query("SELECT * FROM table_name");

// Open CSV file for writing
$csvFile = fopen("data.csv", "w");

// Write data to CSV file
while ($row = $accessQuery->fetch(PDO::FETCH_ASSOC)) {
    fputcsv($csvFile, $row);
}

// Close CSV file
fclose($csvFile);

// Connect to MySQL database
$mysqlDB = new PDO("mysql:host=localhost;dbname=database_name", "username", "password");

// Load data from CSV file into MySQL database
$mysqlQuery = $mysqlDB->query("LOAD DATA INFILE 'data.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'");

// Close MySQL connection
$mysqlDB = null;

Keywords

Access database MySQL database data transfer PHP methods

Related Questions