Possible to use Excel files as datasources? 1

[KCcasey]

Hi,

I'm hoping to import some data from a Excel workbook to use in a report I'm developing. Is it possible without creating custom extensions?

Thanks in advance!

Casey.

 

[Sheco]

Do you want to:
A) Import the data into SQL Server and report off SQL Server.
B) Keep the data in the spreadsheet and report off the .xls file?

If you want choice B then try making a Data Source using the ODBC provider.

 

[KCcasey]

Ack!

I'd had been referencing the DSN unneccessarily in the 'source data' and the 'initial catalog' causing the connection string to fall over.

Ah, while I have your experience onhand, any pointers on how I would go about returning a recordset from from a specfic sheet / cell... ? Will RS accept VBA?

Many Thanks!

Casey

 

[KCcasey]

Sorted myself out!

(For posterity)

Syntax for referencing a specfic sheet:

SELECT * FROM [SheetName$]

Casey.