Export/Import/Update Query Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Here's the scenario that I would like to happen:

I have a table (t_Pit) that I run a select query from. I want the query to
export to a shared folder on a network drive, and have people update that
spreadsheet. Then, I want a macro (set to a timer, which I know how to do)
to either link to or import that spreadsheet, run an Update query to update
the information to the table, and then save the whole kit and kaboodle.
Most of this I know how to do, but I'm getting stuck primiarly on the
importing to the same folder (I know I need to use the Kill function), but
having it linked screws everything up (when I try and relink to the
spreadsheet, it says External File not in Expected format. Although I see it
in my Open File window, it's disappeared from my desktop).
If I can get this going, I will look like a superstar - I will be karmically
indebted to anyone who can help...
Thanks,
Chris
 
Chris,

Why don't you do it the other way? Setup the query in Excel and allow users
when they go in to refresh the query...

Jeff Shanker
 
Chris,

You can use Excel to get external data from Access. Create the spreadsheet
and Import External Data into Excel from you Access database. When a new
user opens the spreadsheet they can click on the red ! and refresh the data.
If that is not what you are looking to do, can you be a little morre specific?

Thanks,

Jeff
 
Thank you - I will start working on that right now. Will this allow the
Excel <-> Access relationship, or will it only be Excel <- Access?
Thanks,
Chris
 
Sorry Chris, but unless you are going to do a lot of VBA programming, it is
going to be one way.
 
Back
Top