Creating a Report.

[dstrat6]

Hi Everybody, I would like to be able to create a report on a Excel sheet made up of data from a SQL Server. Can anyone point me in the right direction. Thank you in advance.

PS. I played around with Pivot's but couldn't get a connection to the local Server. Never worked with before.


Regaurds,
dstrat6

 

[xlbo]

What issue did you have with the pivot table? Should be easy enough as long as you have your ODBC connections set up

Other than that, search for ADO or DAO within this forum - should be loads of examples

Post back with specific issues if you have any

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Andrzejek]

If you need a way to conect your VBA code to your SQL Server Database, look at

http://www.geocities.com/vb_stuff/ADODB.html

First part is about VB 6, but you may find usefull the second part of it.


Have fun.

---- Andy

 

[PHV]

couldn't get a connection to the local Server
Have a look here:

http://www.connectionstrings.com/

and then use MS-query (menu Data -> External data -> ...)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886