Numeric field Overflow

[Guest]

I'm linking to a fixed-length TXT report file, then ran Query to remove
"garbage" rows. The query worked the first time, then gives me "Numeric
field Overflow" error. I'm suppressing rows by selecting Not Null rows in
particular fields.

I understand some of the fields initially contain "garbage" which is
probably cauing the problem.

For resolution - should I be linking as text only, then remove garbage rows
before reformatting particular fields as numerics?

Thanks, Steve

 

[John W. Vinson]

I'm linking to a fixed-length TXT report file, then ran Query to remove
"garbage" rows. The query worked the first time, then gives me "Numeric
field Overflow" error. I'm suppressing rows by selecting Not Null rows in
particular fields.

I understand some of the fields initially contain "garbage" which is
probably cauing the problem.

For resolution - should I be linking as text only, then remove garbage rows
before reformatting particular fields as numerics?

Thanks, Steve

Since we don't know anything about the nature of the garbage, how you're
removing it, or the SQL of the query all I can say is "there's apparently an
error in your query".

John W. Vinson [MVP]