D
dave k
I am using a spreadsheet to and the Get External Data feature to get data
from an Access file. Everything works well as long as the locations of files
don't change. When they do, I used to go into Edit Query and go into the SQL
statement and change the Access data path. But now I have added a parameter
and Edit Query will not allow changes.
Is there a work around for this? Can I make the path for the SQL statement
a parameter and put it into a cell in the spreadsheet? That would be great?
Any help or ideas would be great.
Thanks,
Dave
from an Access file. Everything works well as long as the locations of files
don't change. When they do, I used to go into Edit Query and go into the SQL
statement and change the Access data path. But now I have added a parameter
and Edit Query will not allow changes.
Is there a work around for this? Can I make the path for the SQL statement
a parameter and put it into a cell in the spreadsheet? That would be great?
Any help or ideas would be great.
Thanks,
Dave