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

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