Excel Import Causing Numeric Overflow Error

samjh

Registered User.
Local time
Today, 14:31
Joined
Jan 10, 2013
Messages
64
Hi,

I have a split database that is used by several colleagues. They all have the same front end.

I have buttons which are linked to Macros that will automatically import data from an excel spreadsheet. The filepath to the spreadsheet consists of the full server name as we have some people who have this server on their G drive and other on their N drive.

I have come across a problem where I have one person who pushes the button and gets the Numeric Overflow Error, and someone else who then straight after does exactly the same thing and it uploads the data no problem.

The only difference that I can see between these people is that one of them is linked to G drive and the othe to the N drive, other than that everything else is the same.

Does anyone know why this would happen?
 
Are they trying to upload the same Excel file?

If not, then the problem may be in the Excel file. That error message tends crops up when there's more then one data type in a column. Access guesses the data type based on the first few rows of data, if there's a surprise data type further down, it'll throw the numeric overflow error.

If they are trying to upload the same excel spreadsheet into the same table, then I don't know ;-)
 
Hi,

It is the same excel file they are uploading and one of them can and the other can't and gets the error message.
 
And it's the same Access table too, right? And none of the other people on this drive have the same problem? Hmm, sounds like one of those times Access comes up with an incorrect error number... If the path name is the only thing that is different, there's probably something gone wrong there.

Can you try with a freshly compacted and repaired front-end? Make a fresh copy of the excel spreadsheet, rename it to the original and try to upload that one? Or any of the other things you do when you have no idea what the problem is?

Sorry, not being all that helpful.
 

Users who are viewing this thread

Back
Top Bottom