Re: From MS Access to MySQL
I have taken a Microsoft Access database and have basically copied the structure of it and rebuilt it in MySQL, however, I have encountered some problems with formatting of data. I need to ask what is the most suitable field type to use to retain the content from Access field types The MS Access fields are: Currency (formatted to £ with two decimal places e.g. £10.00) DECIMAL(nnn,2) You'll have to add your own signage ($,£, etc.) upon extraction. Currency (formatted to £#,##0.00;(£#,##0.00) Date/Time (with a Now() default) From the manual: The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in '-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '-12-31 23:59:59'. Yes/No enum() or set() Number (as a percentage) decimal() Number (with field size of Double and Decimal Places of 2) decimal() What would be the equivalent of the above for MySQL 5.1.35? If there isn't an equivalent for some, how can I work around it considering that the Access version of the database is already used in an ASP website? see: http://dev.mysql.com/doc/refman/5.1/en/data-types.html --Curtis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
From MS Access to MySQL
I have taken a Microsoft Access database and have basically copied the structure of it and rebuilt it in MySQL, however, I have encountered some problems with formatting of data. I need to ask what is the most suitable field type to use to retain the content from Access field types The MS Access fields are: Currency (formatted to £ with two decimal places e.g. £10.00) Currency (formatted to £#,##0.00;(£#,##0.00) Date/Time (with a Now() default) Yes/No Number (as a percentage) Number (with field size of Double and Decimal Places of 2) What would be the equivalent of the above for MySQL 5.1.35? If there isn't an equivalent for some, how can I work around it considering that the Access version of the database is already used in an ASP website? Thanks. Mat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Newbie: Transitioning from MS Access to MYSQL
Rodney, Did you EVER get a response to your question ? Im keenly interested to know the answer. M i l e s +++ President Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.magicmiles.com/ [EMAIL PROTECTED] aim/yahoo/msn: magikmiles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie: Transitioning from MS Access to MYSQL
I am new to MYSQL and I want to set-up a database with two or more tables that need to be linked. I come from a basic MS Access background, and in Access linking two tables is done by creating a relationship. Is it done the same way in MYSQL? If so, could someone please shed some light on this matter? Is there a good MYSQL book out there for someone with my background? Thanks! Rodney -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help Transferring Data from MS Access to mySQL
I'm very new to mysql and haven't got much of a background in databases generally, so thanks in advance to any who have the patience to deal with my question. I'm trying to get data from ms access 97 to mysql by exporting to a text file then using the load data command to import it. The data in one of the fields contains all sorts of text, punctuation and formatting characters, even some html tags and linefeed characters (there's all kinds of crap in there). On export, ms access will put quotes around my large text field. I was hoping that mysql would accept everything inbetween the quotes as the field value, but it doesn't...it starts a new record with each linefeed character it encounters. I believe I read that I can change the record delimiter mysql uses from a linefeed to something else, but I don't seem to be able to do the same with the export in ms access (it will let me change the field delimiter but not the record delimiter). I've pretty much resigned myself to writing some kind of script to manually export these records using some kind of unique record delimiter, but I thought I'd check and see if anyone has any other better ideas on how to get my data transferred. Thanks - 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
Re: Help Transferring Data from MS Access to mySQL
At 04:12 PM 11/30/02, you wrote: I've pretty much resigned myself to writing some kind of script to manually export these records using some kind of unique record delimiter, but I thought I'd check and see if anyone has any other better ideas on how to get my data transferred. You'll find all kinds of converters (including Access to MySQL) at: http://www.mysql.com/doc/en/SEC669.html - 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
Re: ....from ms access to mysql
Someone in the list posted the following links. I went with the second one and it worked. NOBBY http://www.convert-in.com/acc2sqlp.htm http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp http://www.winmysql.com/ - Original Message - From: Fabio Amura [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 1:33 PM Subject: from ms access to mysql Hi, i have to migrate from ms access to my sql, and i dont know how can i do... do your know at easy metod for this migration, and can you give me indication or link i'm not an espert... thanks fabio -Messaggio originale- Da: Jochen Kaechelin [mailto:[EMAIL PROTECTED]] Inviato: giovedì 14 febbraio 2002 7.52 A: [EMAIL PROTECTED] Oggetto: Updating SuSE 7.3 Can I use the RedHat-rpms on mysql.com to update a SuSE 7.3 prof or do I need to compile it from source with some parameters? I run 3.23.44 max and I want to update to 3.23.48 max -- Jochen - 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 - 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 - 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
Re: ....from ms access to mysql
Hello, Look on the following page: www.dbtools.com.br. There is a good software which can handle that task. - Original Message - From: Fabio Amura [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 8:33 AM Subject: from ms access to mysql Hi, i have to migrate from ms access to my sql, and i dont know how can i do... do your know at easy metod for this migration, and can you give me indication or link i'm not an espert... thanks fabio -Messaggio originale- Da: Jochen Kaechelin [mailto:[EMAIL PROTECTED]] Inviato: giovedì 14 febbraio 2002 7.52 A: [EMAIL PROTECTED] Oggetto: Updating SuSE 7.3 Can I use the RedHat-rpms on mysql.com to update a SuSE 7.3 prof or do I need to compile it from source with some parameters? I run 3.23.44 max and I want to update to 3.23.48 max -- Jochen - 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 - 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 - 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
....from ms access to mysql
Hi, i have to migrate from ms access to my sql, and i dont know how can i do... do your know at easy metod for this migration, and can you give me indication or link i'm not an espert... thanks fabio -Messaggio originale- Da: Jochen Kaechelin [mailto:[EMAIL PROTECTED]] Inviato: giovedì 14 febbraio 2002 7.52 A: [EMAIL PROTECTED] Oggetto: Updating SuSE 7.3 Can I use the RedHat-rpms on mysql.com to update a SuSE 7.3 prof or do I need to compile it from source with some parameters? I run 3.23.44 max and I want to update to 3.23.48 max -- Jochen - 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 - 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
Cnverting from MS Access to MySQL
Hello again all, Greetings from Scotland. Can anyone direct me to where I can get some free software which will convert an MS Access database to My SQL. Thanks, James Oliver - 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
HELP exporting tables from MS access to mysql
Hi, I have an access database in MSAccess 2000 and I am trying to export tables into mySQL database. I can import tables in MSAccess but cannot export table. When I try to export the table , I get the following error: ODBC--call failed. [Microsoft][Gestionnaire de pilotes ODBC ] Type d'information hors limites (#0) how can i get solve this problem __ Voila vous propose une boite aux lettres gratuite sur Voila Mail: http://mail.voila.fr - 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
exporting tables from MS access to mysql
Hello, I have made an access database in MSAccess 2000 and I am trying to export tables into mySQL database. The problem is, I can export tables with numbers but cannot export table with text or anything. When I try to export the table with a text column, I get the following error: ODBC--call failed. [Microsoft][ODBC Driver Manager (#0) *** Nirzari Desai QUT Web Development Team Phone: +61 7 3864 9308 Email: [EMAIL PROTECTED] Location: 126 Margaret St, Level 11 - 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
Re: exporting tables from MS access to mysql
Hi Nirzari Please visit the following link, for the work around solution and let us know whether this solves your problem. http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:10836:200106:jnlcikigopenhfhco bba Also, for ODBC related postings/queries, please use ODBC discussion group [EMAIL PROTECTED] that way you will be exposed to the real ODBC users. Please visit http://www.mysql.com/documentation/lists.html for more details about MySQL mailing lists. Thank you Venu Anuganti - Original Message - From: Nirzari Desai [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 9:21 PM Subject: exporting tables from MS access to mysql Hello, I have made an access database in MSAccess 2000 and I am trying to export tables into mySQL database. The problem is, I can export tables with numbers but cannot export table with text or anything. When I try to export the table with a text column, I get the following error: ODBC--call failed. [Microsoft][ODBC Driver Manager (#0) *** Nirzari Desai QUT Web Development Team Phone: +61 7 3864 9308 Email: [EMAIL PROTECTED] Location: 126 Margaret St, Level 11 - 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 - 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