Export of text fields from Access2000

Hello,

I export a table from Access 2000 on WinXP to MySQL using the MyODBC =
3.51.04 and text fields are exported as text fields from Access instaed =
of varchar as it should logically be (MEMO is the Access equivalent for =
Mysql text type).

I have Jet SP6 and latest MDAC installed. Is there a workaround from =
this?

PLEASE send message to idvorak@centrum.cz if you know what to do.

Thanks.

Ivo

How-To-Repeat: Create a table in Access2000 with a text(20) field and =
try to export it to Mysql.


------------------------------------------------------------ ---------
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 bugs-thread12695@lists.mysql.com
To unsubscribe, e-mail

RE: Export of text fields from Access2000

Hi !!

> -----Original Message-----
> From: Ivo Dvorak [mailto:idvorak@centrum.cz]
> Sent: Friday, October 11, 2002 12:17 PM
> To: bugs@lists.mysql.com
> Subject: Export of text fields from Access2000
>
>
>
> Hello,
>
> I export a table from Access 2000 on WinXP to MySQL using the
> MyODBC 3.51.04 and text fields are exported as text fields
> from Access instaed of varchar as it should logically be
> (MEMO is the Access equivalent for Mysql text type).
>
> I have Jet SP6 and latest MDAC installed. Is there a
> workaround from this?
>
> PLEASE send message to idvorak@centrum.cz if you know what to do.
>
> Thanks.
>
> Ivo
>
> How-To-Repeat: Create a table in Access2000 with a text(20)
> field and try to export it to Mysql.

I did tested this with Access 20002 with MyODBC 3.51.04;
and I get exported the text fields as varchar and memo fields as
text fields only (because that's how the Access maps to data sources,
and nothing that driver does there). I am using Latest Jet and MDAC
2.7.

Create table : Table test_txt_export(text_col text(20), memo_col memo)

Here is the exported table:

mysql> use test
Database changed
mysql> select * from test_txt_export;
+----------+----------+
| text_col | memo_col |
+----------+----------+
| venu | anuganti |
| ramana | anuganti |
+----------+----------+
2 rows in set (0.00 sec)

mysql> show columns from test_txt_export;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| text_col | varchar(20) | YES | | NULL | |
| memo_col | mediumtext | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)

mysql>

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306
<___/ www.mysql.com USA




------------------------------------------------------------ ---------
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 bugs-thread12703@lists.mysql.com
To unsubscribe, e-mail