| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - query an Access table - results in Excel
Using VBA, I want to query an Access database table which has 240,000
records. The data I am quering for is from a worksheet (sheet1) and I would like the results stored in an Excel worksheet (sheet2). The results from the query will be only a few thousand records, never greater than 10,000. The Access db and Excel sheet are on the same PC. Eventually I will need to query the Access DB from a different PC across a network. What is the best way to do this? Thanks, rirus |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No Results returned from Access query | Excel Discussion (Misc queries) | |||
| Why are access query results different in Excel | Excel Discussion (Misc queries) | |||
| Access query results to Excel | Excel Discussion (Misc queries) | |||
| Copy the results of an Access query into an Excel spreadsheet | Excel Programming | |||
| Linking a table in Access to a table in Excel using MS Query | Excel Programming | |||
Threaded Mode
