[nmglug] MS Access -> MySQL

[J. Marsden DeLapp]

Gary Sandine wrote:
> Hi Mars,
> 
> On Thu, Nov 29, 2007 at 10:01:41PM -0700, J. Marsden DeLapp wrote:
>> One of the tasks is converting a MS access database to MySQL and
>> some sort of user interface that runs on Gnu/Linux. I was thinking
>> maybe Knoda for the frontend or maybe do it with PHP. I currently
>> use this database in my business to manage projects, time sheets,
>> expenses and billing.
> 
> Programs from the Debian package mdbtools can be used to extract
> table schema (for MySQL and others) and data (in csv) from an Access
> 2000/2002 (JET4) or older (JET3) database:
> 
> http://mdbtools.sourceforge.net/
> 

Thanks for reminding me about mdbtools. I used that awhile back to extract some data from another database but could not 
remember how I did it.

That is exactly what I need for the data extraction.

Mars

-- 
=============================================================
J. Marsden DeLapp, PE
President
DeLapp & Associates, Inc. dba DeLapp Engineering®
Providing lighting and power planning, design and analysis services
for commercial, industrial and large residential facilities.
1190 Harrison Rd Ste 3a
Santa Fe NM 87507
(505) 983-5557
http://DeLapp.com
=============================================================