Re: field def problem when importing from Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Oct 1, 10:33 pm, "Keith G Hicks" <k...@xxxxxxxxxxx> wrote:
I read this webpage:http://dailydoseofexcel.com/archives/2004/06/03/external-data-mixed-d...
es/
And my setting is hex 19 (decimal25). Which makes no sense becausehttp://support.microsoft.com/kb/189897says it cannot be higher than 16.
I don't see what this will do to solve my problem anyway. All that should do
is to tell Access to scan 25 rows instead of 19.

I think the KB articles means that 16 is the considered maximum e.g.
you can specify a higher value but it won't be honoured. I suggest you
change the value to zero, which should result in *all* rows being
scanned.

Jamie.

--


.

Relevant Pages

  • Re: ActiveX CAB Problems
    ... Hmm... ... it looks as if some of the articles I was thinking about ... specify that or even which version of Windows Update it is referring to ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Convert a string which might be a number to an int
    ... The problem is that if you really want to know if the string was in the correct format then you need to catch an exception which to be honest is a bad technique. ... ConvertTo returns zero in the case of an error which is bad because every mathemetician will scream that zero is a real number and is valid on it's own. ... Find great Windows Forms articles in Windows Forms Tips and Tricks ... Answer those GDI+ questions with the GDI+ FAQ ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Division by zero
    ... an item and a directional association ... specify how many times one item is included in or excluded from another ... sign&count, count is 1, 2, etc, but not zero. ... numbers beyond what is written in the referenced papers, ...
    (comp.theory)
  • Re: 0 ALLOCATE
    ... should take so it became a defacto "ambiguous condition". ... When there was general agreement as to what the correct response should be, ... When agreement could not be achieved (e.g. because there were inconsistent responses in existing code, or conflicting needs such as the need to avoid the overhead of checking for divide by zero in time-critical apps, or other reasons) we got "ambiguous conditions". ... has to specify what it means and what happens. ...
    (comp.lang.forth)
  • Re: Did native Americans cultivate Lime tree?
    ... > i meddelandet ... >> Please specify. ... > That part will be in one of my articles. ...
    (sci.archaeology)