469,330 Members | 1,373 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,330 developers. It's quick & easy.

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?
May 9 '07 #1
3 1996
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
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
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.

Similar topics

2 posts views Thread by Jonathan Hunt | last post: by
1 post views Thread by R0bert Nev1lle | last post: by
2 posts views Thread by Robert McEuen | last post: by
25 posts views Thread by Ashutosh Iddya | last post: by
7 posts views Thread by Vivek Mohan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.