Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 01-29-2007, 03:27 PM   #1
Registered: May 2006
Location: Tennessee et. al
Distribution: Debian Sid, Etch
Posts: 138

Rep: Reputation: 15
MS Access migration horrors

I am the admin for a local office network running a samba server on Debian Linux for about 30 clients. On the server I have a contact database with 36000+ entries, and a form-based gui coded in vbscript. Due to the plethora of bugs I'm having with Access, I want to switch to mysql with a web-based front end. Does anyone know an easy way to migrate my data to mysql. Also, if possible, I would like to avoid hand-coding the web-based cgi front end, but I need it to be close enough to the original interface so as to not completely confuse the office staff. Does anyone have any recommendations?
Old 01-29-2007, 03:41 PM   #2
LQ Guru
Registered: Dec 2005
Location: Somewhere on the String
Distribution: Debian Wheezy (x86)
Posts: 6,094

Rep: Reputation: 271Reputation: 271Reputation: 271
I'm not even good enough to be called a novice w/ Access, but here's a howto someone here at LQ wrote earlier this year:

Here's another link from google:

As for the form, I don't have any idea...
Old 01-29-2007, 03:42 PM   #3
LQ Guru
Registered: Oct 2005
Location: Willoughby, Ohio
Distribution: linuxdebian
Posts: 7,232
Blog Entries: 5

Rep: Reputation: 190Reputation: 190
Can't you simply export the tables from access to csv or similar format then import that data into mysql >

alternately you could consult the Microsoft to MYSQL Migration guide on MySQLs' web site.
Migration Tools

There are a wide variety of tools available to help you migrate a SQL Server or Access database 
to MySQL. We'll look at several different tools so you can choose the one that best suits your 
needs. The tools we will look at will include the following:

    * Microsoft DTS
    * SQLyog
    * Access Export
    * Text Import/Export

SQLYog and the Microsoft DTS wizard offer graphical interfaces that can be used with both MSSQL 
and Microsoft Access to import tables into MySQL. MSSQL2MYSQL is a script by Michael Kofler that 
can convert not only the table structure and data, but converts the index information as well. 
If you use Microsoft Access you may not have access to the above tools, but you can use the 
data export features of Access.

Last edited by farslayer; 01-29-2007 at 03:44 PM.
Old 01-29-2007, 04:21 PM   #4
Registered: May 2006
Location: Tennessee et. al
Distribution: Debian Sid, Etch
Posts: 138

Original Poster
Rep: Reputation: 15
Thanks for the links. I think for now I will migrate the data to mysql, and create links in the Access database to the data on the server, that way I can continue to use the interface the users are familiar with. Once my plans for switching our office completely to Linux come closer to happening, I'll custom-build the web based front-end.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Suse 10.1 Display Horrors... nanohead SUSE / openSUSE 8 11-04-2006 05:38 AM
The Horrors of WinXP and NTFS v3.1 raven.sorrow General 12 01-22-2005 08:24 PM
rm -rf horrors.... sporkinum Linux - Newbie 1 12-28-2004 11:56 AM
Guru And Lilo...The Horrors again SeptivaOra Linux - Newbie 1 03-14-2004 11:03 PM
microsoft access migration to linux mannybabe Linux - Software 2 04-07-2003 10:47 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 01:01 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration