Numeric field overflow

[OddProject]

Hi guys,

I have a database using link tables from Excel. The Excel spreadsheet itself is linked to another workbook on a sharepoint network.

Yesturday everything worked fine when I put it together.

Now I open a query and it works fine (the first time)... But when I run the query again I get the error 'Numeric field overflow'.

I used a macro:

Sub Addspace()

Dim cell As Object

For Each cell In Selection
cell.Value = " " & cell.Value
cell.Value = Right(cell.Value, Len(cell.Value) - 1)
Next

End Sub

This may work but it erases my links to the shared workbook and leaves me with just the values.

I formatted all the data in Excel but Access changes the format which cannot be changed in a link table.

Anyone get any ideas?

Many thanks

 

[ghudson]

I highly recommend importing the spreadsheets instead of linking to the spreadsheets.

 

[DCrake]

What are you trying to do with the cell values. Numeric Data Overflow usually refers to number that are larger than an integer when an integer has been declared.

David

 

[gemma-the-husky]

i would display some msgboxes, or add a breakpoint and step through the code

i wouldnt be surprised if its not something to do with trying to add a leading space to a numeric field, though

but what are you trying to do - all you seem to be doing is adding a space, and then deleting the space