Overflow error trying to import a wide CDTF

[MLH]

A wide comma delimited text file import into A97 failed
with an overflow error. I'm estimating it to have been
no more than 1000 records. 100% of all the fields were
quoted strings or ZLS's.

What most likely caused the overflow?
Might it be upper limit on number of fields in table?

[ARC]

Re: Overflow error trying to import a wide CDTF

Is it an overflow on a text field, or numeric?

I've seen crazy things with importing from .xls. I had a text field in the
temp. holding table, but because the user had all numbers in the text
column, excel exported as numeric data, and for some reason an overflow
occured (even though I had defined the import table field as text.

Could be something similiar if the overflow is occuring in what you expect
to be a text field.

Andy

"MLH" <CRCI@NorthStat e.netwrote in message
news:2kh443d0qm pebtpmsgg7un0nk ul6jp5j9d@4ax.c om...

>A wide comma delimited text file import into A97 failed
with an overflow error. I'm estimating it to have been
no more than 1000 records. 100% of all the fields were
quoted strings or ZLS's.
>
What most likely caused the overflow?
Might it be upper limit on number of fields in table?

[King Ron]

Re: Overflow error trying to import a wide CDTF

On May 9, 5:12 pm, MLH <C...@NorthStat e.netwrote:

A wide comma delimited text file import into A97 failed
with an overflow error. I'm estimating it to have been
no more than 1000 records. 100% of all the fields were
quoted strings or ZLS's.
>
What most likely caused the overflow?
Might it be upper limit on number of fields in table?

Access IS limited to a maximum 255 columns in a single table and 2000
characters in a single record...

See the online help for 'Access Specifications'

Ron, King of Chi

[MLH]

Re: Overflow error trying to import a wide CDTF

Access doesn't specify. Excel imports it just fine.
I then was able to import it from the Excel file.
Don't ask why.