Linking Excel and SQL

23 Jan 2006 4:25 PM

Preacher Man

I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do I
need to start?

For example. I would like to have a cell in Excel that gives me the sum of
Sales Orders in my SQL Database. I would also like for this to be able to
change according to a date field in excel that can be set.

Thanks for any help.

23 Jan 2006 6:15 PM

Preacher Man

So far I have tried using Microsoft Query, and I have entered my Select
statement. Here's another question though,

How do have a select statement that changes according to what is in a cell
in Excel. For Example:

Select <field> from <table> where <field>=<Cell in Excel>

Show quoteHide quote

"Preacher Man" <nospam> wrote in message
news:elnkSnDIGHA.3944@tk2msftngp13.phx.gbl...
>I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do
>I need to start?
>
> For example. I would like to have a cell in Excel that gives me the sum
> of Sales Orders in my SQL Database. I would also like for this to be able
> to change according to a date field in excel that can be set.
>
> Thanks for any help.
>

24 Jan 2006 12:57 PM

Uri Dimant

Hi
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\External\MyExcel.xls";
User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$

Show quoteHide quote

"Preacher Man" <nospam> wrote in message
news:elnkSnDIGHA.3944@tk2msftngp13.phx.gbl...
>I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do
>I need to start?
>
> For example. I would like to have a cell in Excel that gives me the sum
> of Sales Orders in my SQL Database. I would also like for this to be able
> to change according to a date field in excel that can be set.
>
> Thanks for any help.
>

Thread options