"arkiboys2" <arkiboys2@discussions.microsoft.com> wrote in message
news:4AD42250-20F5-413E-943A-0BE56A31535B@microsoft.com...
> Ther eis an excel file.
> This file is open all the time so the excel sheets get populated by an
> external third party application real time.
> So the data inside the spreadsheets are constantly changing. This
> spreadsheet is only capable of being updated with data when it is open.
> And I would like to import this excel data on a certain interval into sql
> server 2005.
> Tried using the import wizard but it seems the import does not work if the
> source i.e. the excel file is open.
> Is there an alternative please?
> Thanks

"arkiboys2" <arkiboys2@discussions.microsoft.com> wrote in message
news:7C95299B-8C71-4DE1-BFC3-16AA00984D2E@microsoft.com...
> So I guess this can only be done using SSIS but not the wizard, right?
>
> "Francisco A. Gonzalez" wrote:
>
>> Hi
>> If you use an Excel source within an dataflow in ssis, you can load the
>> date
>> while it is open.
>>
>> cheers
>>
>> --
>>
>> Francisco A. Gonzalez
>> fgonzalez@solidq.com
>>
>>
>>
>> "arkiboys2" <arkiboys2@discussions.microsoft.com> wrote in message
>> news:4AD42250-20F5-413E-943A-0BE56A31535B@microsoft.com...
>> > Ther eis an excel file.
>> > This file is open all the time so the excel sheets get populated by an
>> > external third party application real time.
>> > So the data inside the spreadsheets are constantly changing. This
>> > spreadsheet is only capable of being updated with data when it is open.
>> > And I would like to import this excel data on a certain interval into
>> > sql
>> > server 2005.
>> > Tried using the import wizard but it seems the import does not work if
>> > the
>> > source i.e. the excel file is open.
>> > Is there an alternative please?
>> > Thanks
>>
>>
>>