EXCEL SQL Server Connection Question

Check out this EE article and scroll down about 40% of the way to view instructions with screen shots.

Thank you so much for the article. I learned somthign from it and tested it on a blank Excel.
But what I wanted to achieve are:
In the connection properties dialog box,
1. there is nothing in the "connection file";
2. the Proder = SQL Server, not SQLOLEDB.

How to get these two things? The options in Excel's "From Other Sources" confuses me greatly.

Jennifer

If you provide a connection string then you won't need to have a connection file. Connection file should be a .UDL file, I guess.
The provider is what you have installed for SQL Server connection. What do you have? MSSQL Native Client (SNAC)? .NET (ADO)? ODBC`? OLEDB?

Thanks. I have SQL Server and Excel.

Excel but no VBA code.

I mean drivers not applications. Which drivers do you have installed?

Drivers? How to check what drivers installed? I am new to this.
Thanks a lot.
Jennifer

If you check in you connection string the first word is DRIVER and you have SQL Server written on it. You can verify the installed drivers in Windows menu Start / Control Panel / Administrative Tools / Data Sources (ODBC) / Drivers tab.
You should see I list now. What you have listed for SQL Server?

In the "Connection Properties" dialogue box, there is a Connection string box. In it,
I have "Provider=SQLOLEDB.1;;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=..."

Is my driver SQLOLEDB, then?

Yes, in that case you are using SQLOLEDB.

And on the "Data" ribbon, there are 5 choices on the list of "From Other Sources". I don't know which one I should choose:
1. From SQL Server
2. ...
3. ...
4. From Data Connection Wizard
5. From Microsoft Query

Thanks for any help.

My query will pull data from a large table in a SQL Server DB and there is a where clause as "systemdate = ?" and the "?" refers to a cell. I don't know which of the above I should use. Thanks.

What are your knowledge in SQL Server area?
And also do you know well the table that you want to connect to?

I have a little bit of SQL Server knowledge, I know select and where clause.

If you know T-SQL then it's good. Chose the first option (1. From SQL Server).
The '?' means that the user will be asked to provide a value. It this case a date to be used in the WHERE clause.

I just tried your suggestion. Thanks.

But it asks for a connection fil and I don't want to use connection file.
I jsut want to use a Sql Query freely style.

I have been reading and seearching on the internet for a few days and seems like there is no sample for this kind of operation. I know this can be done, but non of the tutorials teaches it.

Thank you so much. I think this clears it. You rock!

Jennifer