MSAccess data to MySQL: Fetch MSAccess data and store into MySQL
| Recommend this page to a friend! |
All requests  |
> | MSAccess data to MySQL | > | Request new recommendation | > |  Featured requests |
> |  No recommendations |
MSAccess data to MySQL #msaccess
by Reema Patel - 9 years ago (2015-09-01)
Fetch MSAccess data and store into MySQL
  +3 | I need code for fetch MSAccess data and store into database MySQL directly with one click. |
1 Recommendation
Metabase: PHP Database abstraction layer RDBMS independent
Package of classes that provide DBMS independent access and management of databases.
Currently it features:
o BSD style license.
o Dual API call forms:
* Direct driver class object calls
* Global function calls
o Set of functions that call the selected DBMS driver objects functions supporting when possible:
* Database connection setup with support for connection strings
* Operation error handling
* Query constant data conversion
* Direct queries
* Prepared queries
* Query result rows random access
* Retrieve a limit range of rows of a SELECT query.
* Nested transactions
* Large object fields (BLOBs - storing files in the database)
* Database object creation (tables, indexes, sequences)
* DBMS driver supported feature query
o DBMS Drivers classes that support the most important databases being used on the Web.
o Driver conformance test suite to verify if the driver classes are working and features are properly implemented.
o A parser class that is able to interpret DBMS independent database schemas file defined in a custom XML format supporting the following types of objects:
* Tables with fields of the types: text, integer, boolean, date, time, timestamp, decimal, float, character large objects (CLOBs) and binary large objects (BLOBs), auto-increment.
* Primary keys
* Indexes
* Auto incremented sequences
o A manager class that is able to:
* Install a new database from a schema description interpreted by the parser class.
* Ability to compare a previously installed schema with a new schema and only install the changes without affecting data stored after the previous installation or update.
* Dump database structure and contents in the same XML format handled by the parser allowing for moving data between databases of different DBMS vendors.
* Reverse engineer schemas of already installed databases
o Driver classes for multiple databases:
* MySQL using the traditional MySQL extension or MySQLi
* PostgreSQL
* Oracle using oci extension
* Microsoft SQL server using the mssql extension
* SQLite
* Generic ODBC base driver
* MS Access using ODBC
* Interbase
* Informix
* MiniSQL
Currently it features:
o BSD style license.
o Dual API call forms:
* Direct driver class object calls
* Global function calls
o Set of functions that call the selected DBMS driver objects functions supporting when possible:
* Database connection setup with support for connection strings
* Operation error handling
* Query constant data conversion
* Direct queries
* Prepared queries
* Query result rows random access
* Retrieve a limit range of rows of a SELECT query.
* Nested transactions
* Large object fields (BLOBs - storing files in the database)
* Database object creation (tables, indexes, sequences)
* DBMS driver supported feature query
o DBMS Drivers classes that support the most important databases being used on the Web.
o Driver conformance test suite to verify if the driver classes are working and features are properly implemented.
o A parser class that is able to interpret DBMS independent database schemas file defined in a custom XML format supporting the following types of objects:
* Tables with fields of the types: text, integer, boolean, date, time, timestamp, decimal, float, character large objects (CLOBs) and binary large objects (BLOBs), auto-increment.
* Primary keys
* Indexes
* Auto incremented sequences
o A manager class that is able to:
* Install a new database from a schema description interpreted by the parser class.
* Ability to compare a previously installed schema with a new schema and only install the changes without affecting data stored after the previous installation or update.
* Dump database structure and contents in the same XML format handled by the parser allowing for moving data between databases of different DBMS vendors.
* Reverse engineer schemas of already installed databases
o Driver classes for multiple databases:
* MySQL using the traditional MySQL extension or MySQLi
* PostgreSQL
* Oracle using oci extension
* Microsoft SQL server using the mssql extension
* SQLite
* Generic ODBC base driver
* MS Access using ODBC
* Interbase
* Informix
* MiniSQL
+4 |
The only way I know to access Microsoft Access databases is using ODBC drivers. The Metabase package can connect to a MS Access database using the odbc-msaccess driver. It can also connect to MySQL databases. So it is a matter of creating two connections and query one database and insert the data in another database. |
by Manuel Lemos 
- 1 Comment
1.
by Reema Patel - 9 years ago (2015-09-03) Replyok thankss
| Recommend package | |
|
|
