Thread: how can a novice start using sql drill with excel

I do not know what to do after installing sql drill. I see the options. I have 11,000 rows in my excel and looking to run sql scripts to get data and create graphs. Any help to a novice like me is greatly appreciated.

Regards,
Satya

Hi Satya

Sorry for delay. I got your email by the way. Thanks very much for posting to the forum though - someone else might benefit from this issue..

For using the add-in = there is no real documentation setup so it is a matter of playing around with it a bit. It is not hard to use at all but at first it can be a bit messy.

If you are trying to query against an excel spreadsheet - you need to use a connection string similar to the follwing:

Code:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SomeFolder\Book1.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

You will need to change the path in the string above to point at the excel workbook you want to use as a data source.

Once you have your data connection setup, you should be able to connect to the data source and start to setup your query.

One thing that is impotant to note is that Excel needs the SQL Statement to be setup in a special way (table names with square brackets) i.e.
SELECT * FROM [sheet1$] However, you should be able to drag accross the tables from and setup the query in this way.


Please let me know how the above goes. I hope this gets you going but if you have any issues at all please let me know.

Thanks
Al