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
-
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
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
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:
[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
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
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