I would recommend that you use perl.
1. Install perl on your Windows box. I use Active State's
distribution. 2. Install DBI, DBD::ODBC, and DBD::mysql. The commands you use
are: ppm install DBI
ppm install DBD-ODBC
ppm install DBD-mysql3. Create a DSN for your Access database.
4. Now you can write perl scripts to read data from one database
and write to the second database.I would expect that you will have some data conversions issues that you will have to work through. For example, as I remember Access has a weird format for dates. You put a '#' in literals when you specify them. The good think about using perl is that you can handle all of these problems.
Hope that helps,
Bill
+--------------------------------------------------- | Bill MacAllister | 14219 Auburn Road | Grass Valley, CA 95949
--On Saturday, March 26, 2005 10:35:04 AM -0500 Ricky Groleau <[EMAIL PROTECTED]> wrote:
Microsofts Acesss that makes ASP pages. The databsae is saved as MDB. Yes, it does have a uplink, my problem is lack of experience with SQL. It asks for localhost, but of course that i smy computer and I dont have any SQL or anything on it. I tried to send it to my sever, but I am lost..is it the IP or web address? Where is SQL hidden on a linux/apache server?
-------Original Message-------From: "Rhino" Subject: Re: Need help coverting MDB > SQL Sent: Mar 26 2005 10:26:58
----- Original Message ----- From: "Ricky Groleau" To: Sent: Saturday, March 26, 2005 10:13 AM Subject: Need help coverting MDB > SQL
> > > Hello, > > I have tried and i have failed. I am trying to help out a non-profit > site in their move. The old site had a forum run by MDB and in the transfer as you know...it won't work. I have used PHPBB and I like it and want to use it. We need to convert the MDB to SQL. I have DL 2 converters...and MySql......again I have failed. The database is almost 9 meg. I need someone that can convert this for me and then explain how to upload since it is so big. I have read you cannot to it thru the web/mysql? > > Any help...guidance....PLEASE! >
I'm not familiar with MDB but I'm assuming that it is some kind of database, like DB2 or Oracle. Does MDB have any kind of export facility? All of the good databases - and even a lot of lousy ones - have some way to convert the database format into one or more text files. There might be a single file for all of the data or a separate file for each table in the database.
If MDB has such a facility, you can almost certainly use MySQLs import facilities to convert the export files from MDB into MySQL tables.
Does MDB have some kind of export capability? If you don't know, can you point me to where the MDB documentation is located online and perhaps I can figure it out for you.
Rhino
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]-------Original Message-------
+--------------------------------------------------- | Bill MacAllister | 14219 Auburn Road | Grass Valley, CA 95949 | 530-272-8555
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
