I do not recommend trying to install a new language if you don't need to. Windows Scripting Host, DAO, and ADO are already installed on most windows machines and are the "native" way of dealing with tasks that the other scripting languages (like PERL) take care of on other platforms.
My alternate suggestion is to download a free database conversion tool (there are several out there, none of which can I recommend because I haven't used them) and let it automate the conversion for you. Search this list for other threads to get some suggestions. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Bill MacAllister <[EMAIL PROTECTED]> wrote on 04/01/2005 05:39:44 PM: > 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-mysql > > 3. 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] >
