Resource of excel to connection mssql to get data
 

Dear all
does anyone know any resource for excel to connect mssql to get data

Resource of excel to connection mssql to get data
 

Try here.....

http://dev.mysql.com/doc/mysql/en/MyODBC_clients.html


"Joe" wrote in message
...
Dear all
does anyone know any resource for excel to connect mssql to get data

Resource of excel to connection mssql to get data
 

Nigel interpreted mssql as mysql. If you just mean access Access or SQL
Server, then ADO.

http://www.erlandsendata.no/english/...php?t=envbadac

or Andy Wiggins' site:

-------------
Andy Wiggins:
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table and add data to it,
* select data from a table,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
---------------------------

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
Dear all
does anyone know any resource for excel to connect mssql to get data

Resource of excel to connection mssql to get data
 

Thanks, Tom, my eyesights going - I'm in the process of developing aWeb Site
with MySQL so I've got it on the brain!!


"Tom Ogilvy" wrote in message
...
Nigel interpreted mssql as mysql. If you just mean access Access or SQL
Server, then ADO.

http://www.erlandsendata.no/english/...php?t=envbadac

or Andy Wiggins' site:

-------------
Andy Wiggins:
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on
page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table and add data to it,
* select data from a table,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
---------------------------

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
Dear all
does anyone know any resource for excel to connect mssql to get data

Resource of excel to connection mssql to get data
 

It (mysql) may very well have been what the OP meant. On the off-hand
chance that it wasn't . . . some possibilities <g

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
Thanks, Tom, my eyesights going - I'm in the process of developing aWeb
Site
with MySQL so I've got it on the brain!!


"Tom Ogilvy" wrote in message
...
Nigel interpreted mssql as mysql. If you just mean access Access or SQL
Server, then ADO.

http://www.erlandsendata.no/english/...php?t=envbadac

or Andy Wiggins' site:

-------------
Andy Wiggins:
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on
page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table and add data to it,
* select data from a table,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
---------------------------

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
Dear all
does anyone know any resource for excel to connect mssql to get data