[Solved] Import to MySQL db 'No Corresponding Column Type'

[evwool]

I created a database using the MySQL community server. I wanted to import data into it from a Base database.
I dragged the table definition into the MySql database, although it warned me that column types were not recognised (I changed them to what I hoped were recognisable types and the definition imported and looked ok) I was able to type a row of data into it. But when I tried to append the actual data from Base, I got a warning "No corresponding column type could be found" This was for a Text Varchar column which had the size 255 characters.

The other fields were all Integer (integer) fields.
Any ideas? Is it something to do with Sql not recognising Text VarChar? If so, what datatypes do I need to choose in my Base table?

[evwool]

Problem not exactly solved but at least evaded. I created the tables in MySql - I still got the No Corresponding Column Type error when I tried to append data. So I'm copy/pasting the data from my original database in Access into Calc and from there copy/pasting into the MySQL table. I'll mark it as solved but will still welcome comments