If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query not updating new data
I have a spreadsheet with a query importing data via QDBC from a
sql2000 table. The data imported without any issues but it dose not refresh with changes made to the source data table. If we change the source data with a new row, the spreadsheet just wont recognise the new data after click on the Refresh. One way I got around it was to recreate the query. But this is not practical. Is this normal in MS Query? any comments appreciated. Regards, Eddy |
#2
|
|||
|
|||
Query not updating new data
Ed wrote:
If we change the source data with a new row, the spreadsheet just wont recognise the new data after click on the Refresh. One way I got around it was to recreate the query. But this is not practical. Is this normal in MS Query? Not normal in my experience What happens if you view the results in MSQuery after adding a new row. Do you see it? - if not the problem is in the query or the ODBC driver or the database - if so the problem is in transfer to Excel, but I can't think of a circumstance in which this behaviour should happen. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query truncates data | Jake | Running & Setting Up Queries | 3 | June 2nd, 2004 09:56 PM |
Updating data | Frank Kabel | Worksheet Functions | 0 | May 31st, 2004 11:15 AM |
External Data refresh query | BeSmart | Worksheet Functions | 0 | April 30th, 2004 10:26 PM |
data query problem | aaron | Worksheet Functions | 3 | December 22nd, 2003 12:24 AM |
query - search and find data in one sheet from another. | SS | Worksheet Functions | 0 | December 3rd, 2003 08:24 PM |