[SQL And EXCEL] importing data

[rrrctraptor31]

I am looking for a way to import data from a SQL server into and excel spread sheet. HELP!?!?!?!

[si_the_geek]

hi rrrctraptor31,

This would get more (and more appropriate) views in the Database Development forum ;) Anyway, back to the point....

Is this as a one-off process, or do you want to do this repeatedly?

If it is a one-off you can use the tools within SQL Server to get the data out (such as the Export wizard in Enterprise Manager)

If this is an ongoing process you will probably want to write code to do it, so what are you planning to use? (and will the person running this have Excel installed?)

[rrrctraptor31]

i want the excel sheet to not only update upon load but on a specified interval. mostlikely every 10 min - 1 hour

[RobDog888]

You would probably want the code to be in VBA behind the workbook. Is this a shared workbook or for your use only?

[rrrctraptor31]

it is shared

[RobDog888]

That will complicate things a bit but will there be a user in control of the sheet that can make edits or is it open to all?