Access2MySQL

2002-11-02 Thread Sam4Software
Hi, I am trying to import 2 columns from Access to MySQL, I get the right number, but all fields are imported as null. Any suggestion ? Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

RE: access2mysql data types

2002-10-30 Thread Fernando Grijalba
- From: Angelo Carmo [mailto:angelocarmo@;horta.com.pt] Sent: October 29, 2002 20:37 To: [EMAIL PROTECTED] Subject: access2mysql data types Hi people, what is the best type to substitute the boolean type of msaccess tables. Or mysql databases support the boolean type? Angelo

Re: access2mysql data types

2002-10-29 Thread Amittai Aviram
e reverse -- (this example is in C) -- if (!row[0]) puts("The value is false."); Amittai Aviram [EMAIL PROTECTED] - Original Message - From: "Angelo Carmo" <[EMAIL PROTECTED]> aTo: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 8:36 PM Subject: access2m

access2mysql data types

2002-10-29 Thread Angelo Carmo
Hi people, what is the best type to substitute the boolean type of msaccess tables. Or mysql databases support the boolean type? Angelo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:

Re: Access2MySQL

2002-10-29 Thread Daniel Kasak
[EMAIL PROTECTED] wrote: Hi all, After setting the field data type in MySQL to Text, which is the same data type for Access data type where the data is being imported from, the import process was succeful and the same number of rows was imported, BUT I don't see any data in the MySQL, all

RE: Access2MySQL

2002-10-29 Thread Alan McDonald
I use MySQLFront and is creats the tables and imports the data with one click never had a problem Alan > -Original Message- > From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com] > Sent: Wednesday, 30 October 2002 9:15 > To: [EMAIL PROTECTED] > Subject: Access2MyS

Access2MySQL

2002-10-29 Thread Sam4Software
Hi all, After setting the field data type in MySQL to Text, which is the same data type for Access data type where the data is being imported from, the import process was succeful and the same number of rows was imported, BUT I don't see any data in the MySQL, all I see is Null, Null. a