Import wizard limitation
 

I'm importing a file that has records over 2000 characters long, and using
the wizard to break it down into columns. But there seems to be a limit at
character 2,374, so all characters after that will be put into a single cell
in the spreadsheet. Is this an actual Excel limit, and is there a way to
get around this limit, or some other strategy, including using other
applications.

Many thanks in advance.

Are you sure that you didn't exceed the number of columns/fields in a worksheet
(256)?



Sirocco wrote:

I'm importing a file that has records over 2000 characters long, and using
the wizard to break it down into columns. But there seems to be a limit at
character 2,374, so all characters after that will be put into a single cell
in the spreadsheet. Is this an actual Excel limit, and is there a way to
get around this limit, or some other strategy, including using other
applications.

Many thanks in advance.

--

Dave Peterson