import firebird tables into Access databases

irade92 · November 27th, 2013, 12:56 PM

Hi
How to import firebird tables into Access 2010 database
Thanks

HiTechCoach · November 27th, 2013, 10:03 PM

Two methods I use:

1) (PUSH to Access) Export the data from each table to a to CSV with the first row having the field names. Import the CVS files into Access.

2) (PULL from Access) Install the ODBC drives for the database. Next create linked tales using ODBC. Now you can use a Make table query for each table to store the data inside the Access database.

irade92 · November 28th, 2013, 12:52 PM

Quote:

Originally Posted by HiTechCoach

Two methods I use:

1) (PUSH to Access) Export the data from each table to a to CSV with the first row having the field names. Import the CVS files into Access.

2) (PULL from Access) Install the ODBC drives for the database. Next create linked tales using ODBC. Now you can use a Make table query for each table to store the data inside the Access database.

THANKS A LOT