Reply to Joe on truncating question in Access

[Michele]

Hi Joe,

Thanks for the reply. But, I seem to be confused, which
doesn't take much Please bear with me, as I'm a new
user to Access.

As you suggested, I tried to expand the line past 255
characters but I got an error message stating that the
column could not expand past 255.

Another problem is, if I try to expand the column width,
the cell height gets taller, leaving extra space at the
top of the cell?

Any help you could provide is greatly appreciated!

Thanks again.....Michele

 

[Joe Fallon]

Michele,
It is better if you reply in the same thread.
(I watch my own threads.)
I almost missed this additional question since you started a new thread.

My reply had nothing to do with Access and everything to do with Excel.
The first row of data in the Excel spreadsheet needs to include a column of
data that is over 255 characters.
Excel cells can handle way more than this.

e.g.
You have a spreadsheet with these columns:
ID Name Comments
1 Joe some text (be sure to include more than 255 characters here!)
2 Michele some more text
3 Bob extra text


Your "comments" column is the one that is truncating when you import to
Access, right?
The reason is that in Excel, none of the comments in the first 16 rows of
your spreadsheet is over 255 characters.

Better?