[Peter Jamieson]

1) Ticking 'Confirm Conversion at Open' seems to have no effect to
anything
- when I open the document I get no confirmation alert or option screen..
am
I supposed to?

You have to go through the process of connecting to your data source again.
After you have selected the data source (and pressed OK/Open/whatever) there
should be an additional dialog that lets you specify a particular connection
method. What's in there depends on the type of file you are trying to open.

I'd go through that route before looking at the other approaches.

FWIW I find it astonishing and irritating that this kind of limitation not
only still exists, but has actually been introduced in the last 5-10 years.

Peter Jamieson

"borrodell" wrote in message
...
I've now looked round all the discussion forums here, noting that its a
common problem, and noting the common fixes. Just to let you know what
I've
tried in vain:

1) Ticking 'Confirm Conversion at Open' seems to have no effect to
anything
- when I open the document I get no confirmation alert or option screen..
am
I supposed to?

2) Padding out the first row in my Excel sheet with 400character
paragraphs
does nothing to aid the truncation - when viewing that record 6 out of 12
fields show 255 out of the 400 characters of the paragraph, and the other
6
show nothing. The second record is still truncated.

3) Setting TypeGuessRows in the Jet registry entries to 0, in order to get
Excel to look at all the rows does nothing, and when I make 50 rows
brimmed
with 400character paragraphs, it still does nothing.

So... what should I do??!

Thanks,
James