Hello all.
I'm pretty new to Access, so I'm not sure how to go about this...
I have a query that I run using a table and a linked table. The table and
linked table have a relation****p between them. I want to be able to have
the
linked table automatically update before the query actually runs and then
have the results ex****ted to Excel. Of course I could do this manually,
but
since this is a daily procedure it would be nice if I'm able to automate
it.
Based on what I've read I think I'll need to use TransferSpreadsheet, but
I
don't know how to go about this. Do I need to write a macro? I'm not
familiar with VBA for Access, or with SQL. (I've only used VBA for
Excel.)
Any help would be greatly appreciated. Please explain the answer since
I'm
not as familiar with this particular software as whoever answer this
question. ^_^ Thanks in advance.
--
Cheers,
Michelle
"The market can stay irrational longer than you can stay solvent" - John
Maynard Keynes
