SQL to Excel

[shiftlocked]

Just been dabbling around with a few databases and such and for a project im working on, want to get excel to connect to a live db on a website (ok im hosting locally for now but thats not the point )

Anyone done this type of thing before and could lend a hand?

 

[JN]

I'd imagine you'd need to set up an ODBC connection for that SQL server to start with (in Administrative tools). Then in Excel click on Data>Import External Data>Import Data>Connect to New Data Source

Never done it myself, but the above might get you on your way :\

 

[nunzio]

Olap would be your best friend here.. but XMS is right too

Just what SQL software is it?

 

[shiftlocked]

Ah sorry forgot to say that its MySQL

 

[JN]

Ah sorry forgot to say that its MySQL

I _think_ ODBC supports a generic SQL Server - not sure if it will work tho. You might need to install MySQL on your machine to get the proper ODBC config.

Maybe check out nunzio's solution - might be easier than mine.

 

[nunzio]

Ahh.. MySQL doesnt have olap software, as far as i know..

Clicky

That might help.

 

[shiftlocked]

There is method in my madness of wanting to get data from a db into excel. Im sure that i saw something in a query wizard.

FYI im on excel 2007 and cant find nething to do with OLAP though I do recall seeing it