Run SQL-Server Query in Excel

M

Maik Richter

Hi guys,

is there a way to run a SQL-query on a SQL-Server
within Excel?

(Is it possible to create any JOIN-querys and DATEDIFF-functions within
Excel-Microsoft Query?)

Thanks much guys,

Mike
 
A

Amedee Van Gasse

Maik said:
Hi guys,

is there a way to run a SQL-query on a SQL-Server
within Excel?
Click to expand...

Yes.
I don't know it in English but in Dutch it's in Data - Externe gegevens
ophalen - Nieuwe databasequery...
(Is it possible to create any JOIN-querys and DATEDIFF-functions
within Excel-Microsoft Query?)
Click to expand...

I have not needed it before, but I couldn't imagine why not. SQL is
just SQL, right?
Have you tried to search using Google?
Have you tried the websites of Chip Pearson, John Walkenbach, and other
MVP's that are frequently quoted here?
 
A

aaron.kempf

i have an answer for you

throw excel out the window; and don't ever use it again.

it is a one-way street to inefficiency, duplicating business logic

it is literally a disease

use access for reporting and data entry.. access data projects
specifically
 
K

Ken Wright

Another fictitious reply to a non-existent post just to get a rant into the
newsgroups - Petty beyond belief.
 
G

Guest

Access->SQL integration is MUCH more dependable than Excel-SQL integration

for example... you use Access Data Projects in order to write stored procs
and views

can Excel do that?

get a life MVP and learn a real program
 
Top