Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Query Link error
we have a shared spreadsheet ,numerous users access, and there are many
copies, and all r affected: it pulls data from a SQLbase db based on a range of dates. when we open the file we often see this Excel error: [INTERSOLV][ODBC SQLBase driver][SQLBase]02212 EVA NOF Numeric overflow but you click ok, it refreshes the data, and you see the results. we found that if you put in dates for February (eg 2/1/2005 through 2/28/2005) the data stops refreshing and the data disappears. by trial and error i found if you go back to January, and going to the sheet where the query is run from, you can go to DataImport Ext DataEdit QUery and get it to works again, even for February. Is this a connection error? Any suggestions? |
#2
|
|||
|
|||
I don't know anything about the Intersolv driver.
Google showed me other messages on a similar subject (without replies) in other groups, relating to the Intersolv driver. You could try contacting Intersolv: http://www.intersolv.com Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Error on new Data Base Query | Excel Discussion (Misc queries) | |||
Link Access query to refresh an EXCEL file | New Users to Excel | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |