Importing MySQL in MS Access

Importing MySQL in MS Access

am 01.02.2006 05:23:40 von someone92

Hi,
I'm building a shell script that store information in a MySQL 5.0
database. One of the data I store in the table is a text file. I use a
BLOB type for this text data.

If I try to import it in MS Access 2002 the BLOB column is converted
to a OLE type, but when I try to open it in access I get this error:

"A problem occurred while Miscrosoft Access was communicating with the
OLE server or ActiveX Control. Close the OLE server and restart it
outside of Microsoft Access. Then try the original operation again in
Microsoft Access."

I know that it's because MS access doesn't know what type of object it
is and with which program it should open it. But I don't know how I can
tell access the type of object it is. Should I create a module to
handle these objects? I'm new to access databases so I don't know where
I should start. If someone has any tips or codes I should use please le
me know.

Should I use another type instead of BLOB?

By the way the MySQL database is created from mysql command line inside
a shell script.

Thanks in advance