If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating automatic reports in Excel using Access
I am looking for a way to automatically create several unique excel reports
using my access database. I am not well versed with SQL so I am not sure where to begin. Can anyone offer some help as to what my first steps should be? Should I be creating the template for my reports in excel and then querying with Visual Basic in excel? Or should I start with pulling the data within access and creating the query there? I've been searching for step-by-step information but haven't had much luck so far. Thanks in advance! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200908/1 |
#2
|
|||
|
|||
Creating automatic reports in Excel using Access
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportToExcel.mdb" which illustrates one way to do this. You can find it he http://www.rogersaccesslibrary.com/f...ts.asp?TID=350 -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "tessaco via AccessMonster.com" u53691@uwe wrote in message news:9a897bd0afe9e@uwe... I am looking for a way to automatically create several unique excel reports using my access database. I am not well versed with SQL so I am not sure where to begin. Can anyone offer some help as to what my first steps should be? Should I be creating the template for my reports in excel and then querying with Visual Basic in excel? Or should I start with pulling the data within access and creating the query there? I've been searching for step-by-step information but haven't had much luck so far. Thanks in advance! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200908/1 |
Thread Tools | |
Display Modes | |
|
|