In response to Jacques post on 3/8/2007:

When I use the following create statement, it gives the error "Size of field column3 is too long". It does not solve the core issue of being able to create a field greater than 255 chars.

CREATE TABLE `Sheet_name` (

`column1` VARCHAR(10),

`column2` VARCHAR(50),

`column3` VARCHAR(1000)

)