Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-06-2019, 09:00 AM   #1
timothy.corbin
Newly Registered User
 
Join Date: Apr 2019
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
timothy.corbin is on a distinguished road
Exporting to Excel worksheet based on dates

SO....
The attached DB is being designed for use in grocery store produce departments. Users input data related to what is being thrown away, and it produces a report that rolls up that information.
I was working on a way to export the data so that it could be sent digitally to managers at higher headquarters, but they specifically want it in Excel.
Yes. Excel. Barbarians and Heathens all!
With that in mind, I am trying to create a widget within this DB that allows the user to export the data from Access to Excel, and the data would auto-populate worksheets within a workbook based on the date from the data.
How would this be possible? I've already created a query (Export) that gathers the necessary information, and I can export this in Excel format then cut &past into the Excel Workbook--I am just trying to cut out the middle man and get Access to do it on its own.
Attached Files
File Type: zip SALVAGE v4.zip (1.62 MB, 12 views)

timothy.corbin is offline   Reply With Quote
Old 06-06-2019, 09:12 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 2,960
Thanks: 34
Thanked 711 Times in 694 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Exporting to Excel worksheet based on dates

Hi. Have a look at some of the Excel Automation articles at this website.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 06-06-2019, 09:22 AM   #3
timothy.corbin
Newly Registered User
 
Join Date: Apr 2019
Posts: 11
Thanks: 2
Thanked 0 Times in 0 Posts
timothy.corbin is on a distinguished road
Re: Exporting to Excel worksheet based on dates

Thanks!
Headed there now!

timothy.corbin is offline   Reply With Quote
Old 06-06-2019, 09:32 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 2,960
Thanks: 34
Thanked 711 Times in 694 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Exporting to Excel worksheet based on dates

Quote:
Originally Posted by timothy.corbin View Post
Thanks!
Headed there now!
Good luck and let us know how it goes or if you get stuck.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
export excel xLsx Worksheet to Worksheet xlsm Joe8915 Excel 1 05-29-2012 08:24 PM
Exporting single Query result to Excel Worksheet vnfoster Modules & VBA 0 10-19-2009 12:48 PM
Exporting Access table to Existing Excel worksheet kfschaefer Modules & VBA 0 07-31-2006 12:43 PM
Exporting to a specific excel spreadsheet, and a specific worksheet/cells Big2 General 4 10-07-2005 01:28 AM
Import From Excel based on Worksheet's Column Headings Dugantrain Modules & VBA 2 06-06-2003 12:04 PM




All times are GMT -8. The time now is 08:30 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World