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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automation 4
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
Checking data in consecutive rows and returning a value 1
export to excel from access 2
Transferring files to a HD Nook 5
transferring data to new multiple spreadsheets 1
copy from record set - code advise 1
Transfer data directly to Excel spreadsheet 3

Back
Top