Numeric Overflow Error In Make Table Query

M

Michael C

Any help on this would be great. I have a make table query
that is coming up with a Numeric Overflow error. The make
table query's source is a table that has several columns,
the first column is a text field and the rest are numeric.

I put a "Not Is Null" filter on the numeric columns
because the source table is linked to a spreadsheet whose
first 8 rows are useless information that I don't want
included.

FYI: In all of the table's numeric columns, the first
seven of the source table rows are blank. In the eight row
of my query's source table, I see "#Num!#. That's probably
because the spreadsheet that the table is linked to has
text headers in row eight. I think this row is causing the
problem but I don't know the solution. I need to link to
the spreadsheet because it automatically updates everyday
at 5AM and there are a few of them.

Any thoughts would be much appreciated. Thanks!
 
M

[MVP] S. Clark

Overflow happens when a number is appended to a field that is too small to
handle it. For example Byte is only 0-255. Integer is up to 32,768.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top