I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row! Is there any other way to do this? I need more space!
Problem isn't the way you are importing excel sheet into SharePoint list, I think problem is with SharePoint list as I assume you are using default columns for importing data that is larger then 255 characters which is not supported by default.
Just use column type note and you will have more space. Looks like this is issue that SPFieldText won't allow more than 255 chars, althought it has MaxLength property, it anyway won't allow more chars.
You may read this article on how to create your custom column that can be used to type in more than 255 chars.
So is the question how to import a cell with more than 255 characters in it,
SharePoint lists use datatypes in each column of the data.
Instructions on exporting Excel table to SharePoint list.