Re: MS Access to SQL

Since mySQL is supported on just about any UNIX platform and creating a database is as
easy as >mysqladmin -u root create databasename and then importing a delimited text file
into the newly created database, I'd suggest mySQL. It's also pretty easy to compile with
the Linux Apache setup, and it's really fast and nicely designed. I do not, however, know
how easy it is to get Access to spit out the data in a format that would go straight into
mySQL, though the queries shouldn't be hard. PHP also works really seamlessly with mySQL,
so if you're interested in getting off ASP... :-)

Good luck!

Nathan


----- Original Message -----
From: Eric Peeters <eric(at)connexworks.com>
To: <hwg-techniques(at)hwg.org>
Sent: Tuesday, March 21, 2000 7:04 AM
Subject: MS Access to SQL


Hello gang,

I am working on a project where several people with limited experience of the
web and computers in general (in other words, they're just regular computer
users) will collect and comment bookmarks on various topics. To ease their work
as much as possible, they will be recording the bookmarks in an Access dabatase.
I will merge all their databases into a single one.

However, the web site will be running on Linux with an Apache server and
ChiliSoft ASP. In order to make any use of the Access database, I need to
convert it either to a mySQL or PostgreSQL database, at least until the web site
is up and running and changes can be made directly into the database through a
password protected area.

Does anyone have any idea on how I can convert my database from Access to either
one of the above, and which would be easier.

Thanks in advance,

Eric Peeters

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA