Try MydbPAL at www.it-map.com. Its a FREE product that will do a complete .mdb (access) to My SQL translation - schema and data. There is a learning curver but you can follow the tutorial which takes you thru an mdb conversion
Tim Hayes -----Original Message----- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 26 March 2005 19:28 To: Ricky Groleau; mysql@lists.mysql.com Subject: Re: Need help coverting MDB > SQL Sorry, I don't know how to help you with this; I've never really worked with MDB files or ASPs. I have no experience with the tools that you are using to extract data from the MDB files so I can't answer your questions about IP addresses either. Maybe someone else on this list can help you, although it isn't usually very active on weekends, especially holiday weekends. You could also try posting to one of the many Microsoft newsgroups; I believe there are newsgroups covering ASPs. Another possibility for you is to review the Microsoft manuals. There must be some documentation on how to use MDB files and get data from them. Rhino ----- Original Message ----- From: Ricky Groleau To: Rhino ; Ricky Groleau ; mysql@lists.mysql.com Sent: Saturday, March 26, 2005 10:35 AM Subject: Re: Need help coverting MDB > SQL 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" <[EMAIL PROTECTED]> > Subject: Re: Need help coverting MDB > SQL > Sent: Mar 26 2005 10:26:58 > > ----- Original Message ----- > From: "Ricky Groleau" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > 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 o 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 AntiVirus. > 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------- ---------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005
