Hello,
I'm new to Access but have developed an model which I'd like to export into Excel. The database will house large amounts of payroll data, however, exporting will be narrowed to specific weeks or a range of weeks. The resulting Excel file will then be imported into SAP as a journal entry.
Because of these requirements, I need help learning how to do more advanced exporting techniques. My boss showed me really quickly one day how I could enter a value on the Excel file which was to contain the export, and Access could read that parameter and return the specific week's data I required. The possibility of exporting a range of weeks (useful in analysing hours) would also be a plus. I should mention my boss is out of the country this week and unavailable for guidance.
Is there a tutorial out there on the web somewhere that can detail the steps I require? I'm using Access 2007.
Thank you
Last edited by 2709236; 11-07-2011 at 12:59 PM.
You can create a parameter query in excel which permits you to choose the week you need and then export the result to excel
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
What I was briefly shown was that I could reserve a specific cell in my Excel sheet to inupt which week I required. Then when the export was run from Access, that week's data would be populated. Almost like circumventing the input box that sometimes pops up in Access. Does that help?
Success!
I found one part of my issue. If I go into my destination workbook in Excel, and I choose "get external data" from an access database, I can follow that through and choose the specific cell I want the data to land in.
I still need to know how to make access read a parameter restriction, and I need to know how to make it export data only with no titles.
If you are just looking for examples or tutorials, Google should be able to help you nicely. The first one that popped up for me seemed like it could help you quite a bit:
http://www.fontstuff.com/access/acctut15.htm
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thank you, but that link isn't working it seems.
Yes - tutorials are what I need! And an icepack and some tylenol please.
Wierd, the link works for me. Did you try Google?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
It works now. Must have been on my end.
I appreciate your help with posting the tutorial. I believe I have found what I was requesting. For the benefit of other readers, I'll post the link.
http://office.microsoft.com/en-us/ex...005199548.aspx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks