Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Querying data from Access
Hi I am trying to set up a worksheet querying data from an Access database
on our network. I have set up three colums Ok - this data comes from tables. I am trying to set up the final column, but this data needs to come from a query within Access. I have set up a separate datasource in ODBC and when i link to the query I am getting either "cannot connect to datasource on my C drive" whereas i have set the datasource from our F drive, or else I get a message that the Query editor acnnot access by Query on the F drive. Can anyone help why it works with tables, but not with queries thanks S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
MS Excel data reading in MS Access | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
populating data from excel into access | Links and Linking in Excel |