|
|
|
|
#1
08-11-2021, 03:04 AM
|
||||
|
||||
OK, I ended up with:
1. Excel sheet supplied by colleague with raw data 2. New Excel sheet linked to my coleague's sheet which has the functions I need to make a few extra columns 3. Access database links to the new sheet to give the queries I wanted 4. A 3rd Excel sheet links to the Access queries and presents the results So this is REALLY round-the-houses, but I couldn't replicate all the Access queries in Excel with the level of knowledge I have. At least it works! 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How does an Access query of linked Excel tables decide on field formatting? | junkcarp | Excel | 1 | 09-01-2020 02:43 PM |
| Excel ADO query from Access Not Working | bconner | Excel Programming | 0 | 03-22-2017 09:29 AM |
| Linking specific cells in Excel to function with MergeField? | Fabulist | Word | 0 | 02-17-2016 02:19 AM |
| Using MS Access Query and VBA to create Excel Chart | jrmontgom | Excel Programming | 0 | 04-07-2015 11:21 AM |
 How do I call/execute an Excel macro from Access 2003
|
KramerJ | Excel | 2 | 05-11-2009 11:33 AM |
Windows 7 64bit 
Office 2013
Hybrid Mode