Can someone direct me in the direction for learning how to get a SQL script (using Excel query tools) to present the data in a pre-designed report layout with subtotals, etc. I was able to pull data using the query wizard from a database but every time I run the query, I have to format the data and add subtotals columns and rows. Can Excel get the data from, say, an Access database and drop the numbers into a pre-designed report layout at the push of a button?
HI
Generic answer is yes, you can pull specific data from an access database and nominate the output placement in a spreadsheet.
That said, t'would be difficult to give any meaningful code without having something that is relevant to follow.
Care to dummy something up that can be used as a test bed to work up some code?
As a generic startpoint, go to the microsoft.com web, and do a search on createobject adodb. Have a look at some of the examples given.
rylo
Last edited by rylo; 06-28-2007 at 12:42 AM.
It looks like my need crosses over into programming of which I'm unknowledgeable. But I'm glad to hear that Excel can do it. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks