Help with Advanced Exporting

[2709236]

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

[arthurbr]

You can create a parameter query in excel which permits you to choose the week you need and then export the result to excel

[2709236]

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?

[2709236]

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.

[davegugg]

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

[2709236]

Thank you, but that link isn't working it seems.

Yes - tutorials are what I need! And an icepack and some tylenol please.

[davegugg]

Wierd, the link works for me. Did you try Google?

[2709236]

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