MS Access 2000 and MySQL
Hello, I created a blank table in MS Access 2000 for recieving data from mysql and tried to compile importsql.txt in Access module but I still got the error saying user defined-type not defined. I copy pasted exportsql.txt to the module and got the same error. I have a coworker who told me she never had the problem with Access 97. Is this a problem related to Access 2000? If so, how can I work around it? Thank you in advance. - 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: MS Access 2000 and MySQL
Hi, This error make reference to a variable which is not correctly defined.I suppose that you have in routine which make import a variable like : Dim myvar as lon insted Dim myvar as long Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 9:29 PM Subject: MS Access 2000 and MySQL Hello, I created a blank table in MS Access 2000 for recieving data from mysql and tried to compile importsql.txt in Access module but I still got the error saying user defined-type not defined. I copy pasted exportsql.txt to the module and got the same error. I have a coworker who told me she never had the problem with Access 97. Is this a problem related to Access 2000? If so, how can I work around it? Thank you in advance. - 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: Converting Access 2000 to Mysql
There is a program at http://www.convert-in.com/acc2sqlp.htm which will create the MySQL tables from the Access 2000 database and populates created tables directly from the Access 2000 source. It also converts date/datetime fields into MySQL format and Yes/No fields into tinyint. The best news is that it takes about 1-2 minutes to complete the process {not counting time to load the data}. One caution, if you have Access queries that reference other queries you will have to rework the design until MySQL supports VIEWS {currently targeted for 4.1 according to the manual}. -Original Message- From: Gary Portellas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:46 AM To: [EMAIL PROTECTED] Subject: Converting Access 2000 to Mysql Hi All I am new to Mysql / Linux and would like to import my access 2000 database into a MYSQL database - is there an easy way to do this ?? Thanks Gary - 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
Converting Access 2000 to Mysql
Hi All I am new to Mysql / Linux and would like to import my access 2000 database into a MYSQL database - is there an easy way to do this ?? Thanks Gary - 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: Converting Access 2000 to Mysql
I think the best way is to export Access 2000 tables to tab delimited text files and then use mysql LOAD DATA INFILE in mysql to get data from text files into MySQL tables. See manual for LOAD DATA INFILE syntax. I'm not sure but maybe some utilities exist to convert Access to MySQL. Peter. -Original Message- From: Gary Portellas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:46 AM To: [EMAIL PROTECTED] Subject: Converting Access 2000 to Mysql Hi All I am new to Mysql / Linux and would like to import my access 2000 database into a MYSQL database - is there an easy way to do this ?? Thanks Gary - 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: Converting Access 2000 to Mysql
To convert Access DB to MySQL check this URL http://www.urbanresearch.com/software/utils/urbsql/ theOtherOne - Original Message - From: Gary Portellas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 2:45 AM Subject: Converting Access 2000 to Mysql Hi All I am new to Mysql / Linux and would like to import my access 2000 database into a MYSQL database - is there an easy way to do this ?? Thanks Gary - 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
Migrationfrom Access 2000 to MySQL
We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90 E-mail : [EMAIL PROTECTED]
Re: Migrationfrom Access 2000 to MySQL
At 10:33 AM 7/9/01 +0200, Dominique Vellin wrote: We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement I don't know how much this will help, but I've been using DBTools and it works for me. John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - 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
Question : migration from Access 2000 to MySQL
We have made up our mind to turn our Access 2000 database into a MySGL one. Could you please explain us the path to follow and give us information about it ? Dominique Vellin Business developement Azentis Technology Your Outsourcing Provider Tel : 33 1 42 77 21 02 Mobile: 33 6 82 13 32 90 E-mail : [EMAIL PROTECTED]
Porting data from MS-Access 2000 to MySQL
Hi, I have a database created with all data stored in Microsoft Access 2000. Can someone tell me what would be the easiest and fastest way to port all the data from MS-Access 2000 to MySQL. Any help in this regard would be highly appreciated. Thanks in advance -Ramanbr clear=allhrGet your FREE download of MSN Explorer at a href=http://explorer.msn.com;http://explorer.msn.com/abr/p
Re: Access 2000 and MySQL
At 15:12 12/02/2001 -0500, WJ McEachran wrote: Hi! MySQL doesn't support Windows clustered servers because besides the transaction feature is necessary the development of the resource manager to have the fail over. Regards, Miguel I've just been exposed to Access 2000 :-( I'd be interested in any comments about using Access 2000 as a front-end for MySQL (this isn't _my_ choice). How is it done? What are the pitfalls? Please c.c. me directly as I'm in the process of resubscribing to this list. -- Bill McEachran - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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
Access 2000 and MySQL
I've just been exposed to Access 2000 :-( I'd be interested in any comments about using Access 2000 as a front-end for MySQL (this isn't _my_ choice). How is it done? What are the pitfalls? Please c.c. me directly as I'm in the process of resubscribing to this list. -- Bill McEachran - 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