M
Michelle
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 relationship between them. I want to be able to have the
linked table automatically update before the query actually runs and then
have the results exported 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.
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 relationship between them. I want to be able to have the
linked table automatically update before the query actually runs and then
have the results exported 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.