Hi,
Converting from Access to mySQL:
You can use myaccess from www.mysql.com it's a script to paste in MSAccess
that generates the SQL with tables and data, or
you can use DBTools (http://dbtools.vila.bol.com.br), it's a client for
windows with import wizard to import from MDB/XLS/DBF/DB and ODBC
datasources.
WebPages:
You can use a lot of things, to start you can use:
PHP / Perl, both are used in most of the websites and work in a lot of SO's
including WINNT.
You can use ASP and connect to mySQL using ODBC. I know there's a few
components you can use to connect mySQL directly. I don't remember the URL
right now, but one of them you can find easily at www.scibit.com. There's a
free one, you can search the list to find it.
Hope this helps you.
[]'s
Crercio O. Silva
-----Original Message-----
From: Ciprian [mailto:[EMAIL PROTECTED]]
Sent: quarta-feira, 31 de janeiro de 2001 12:50
To: [EMAIL PROTECTED]
Subject: From MS Access to WinNT-MYSQL-Server
Hi,
I am in "little" trouble.
My task is to build an online database.
The company has the database in MS Access and they need to put it on the
website so people can search the database for the retail store nearest them.
My problem is that I am quite new in MySQL and I don't know:
1) how to transfer the database from MS Access to the SQL server;
2) how to make the webpages that people use to search our online database.
The servers are Windows NT server with MySql support.
I thank you for any answer you may give me.
Ciprian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
