I have a spreadsheet where I run a query in Access and copy it into the specific spreadsheets. I was trying to use Data->import external data->import data tool in excel to get the data automaticly w/o me going into Access and running the query and pasting into the spreadsheet. However, I can go to the database using this tool in excel, but I can not specificy the query name that needs to be run anywhere during the import of the data. Can anyone tell me what I am doing wrong? Thanks!!!
1
