Import Data tool

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nuray
    New Member
    • Aug 2007
    • 1

    Import Data tool

    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!!!
Working...