| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data not updating
Hi,
I have an Excel 2003 worksheet which I have imported external data. This comes from Access 2003 via Microsoft.Jet.OLEDB.4.0(Data - Import External Data - Import Data). When I open the query in Access, it returns 30 odd rows. However, when I import that query into Excel, nothing appears apart from the column headings. If I import data using Microsoft query (Data - Import External Data - New Database Query), it returns the expected results. Hopefully someone can help? Thanks, Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto updating pivot tables using external XML data | New Users to Excel | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| How can I have the Import External Data dialog pop up on open? | Setting up and Configuration of Excel | |||
| Import External Data | Excel Worksheet Functions | |||
| External Data Source updating on open, how to turn back on prompt. | Excel Worksheet Functions | |||
Linear Mode
