By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Overflow error trying to import a wide CDTF

P: n/a
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?
May 9 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ARC
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" <CR**@NorthState.netwrote in message
news:2k********************************@4ax.com...
>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?

May 9 '07 #2

P: n/a
On May 9, 5:12 pm, MLH <C...@NorthState.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

May 10 '07 #3

P: n/a
MLH
Access doesn't specify. Excel imports it just fine.
I then was able to import it from the Excel file.
Don't ask why.
May 11 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.