automaing file transfers

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

Guest

I have a file in Excel with about 10 tabs. All the tabs contain data from 10
different queries from access database. I copy and paste the data from 10
queries to Excel File everday which is very tedious and time consuming. Is
there a way to automatically transfer the queries to respective tabs each day
so that I don't have to use copy and paste method? It will result in accuracy
also. Can someone help?

Thanks,


Purnima Sharma
 
Back
Top