Post reply

It is possible to use Excel as Data Source?

  • February 8, 2008 at 2:31 am

    #182475

    Hi to everyone,

    I have an upcoming Reporting Services development in which the requirements states that data will be coming in from an Excel Sheet. Is this possible? I read some forums and they have only provided way to connect to Excel and not much about getting the actual data (to be used in the DataSet). Any help will be appreciated.

    Thank you so much!

  • February 8, 2008 at 6:57 am

    #776390

    Yes.

    The most significant difference between using Excel and a typical SQL data source is the data source type selection.

    Before you start, make sure you have Excel Files set up as a Data Source Name on your machine.

    On your Data Source dialog screen, click the Type: drop down and select OBDC. Then on the Connection Properties dialog, select the Connection string option and build your string using the Build button.

    The next dialog has two tabs, File Data Source and Machine Data Source.

    If you see Excel.dsn on the File Data tab, select it and click OK. The next dialogs will lead you through actually selecting the workbook to use.

    If you don't see Excel.dsn, select the Machine tab and scroll and select the Excel Files Data Source Name. Click OK and select your workbook from the subsequent dialogs.

    After that SQL query scripting should work let you create data sets from the new data source.

    HTH

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply