Import wizard limitation

  • Thread starter Thread starter Sirocco
  • Start date Start date
S

Sirocco

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)?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel text export limit - 1024 per line (not cell), workaround? 11
cell character limit 8
number of characters in each cell 5
How to limit cell to 30 characters or less 2
Chracter Limit Help!! 7
limit number of characters in cell 4
"Centre Across Selection" and character limit 1

Back
Top