Transferring data

[Developer]

Hi,
I have a situation when I have to get all data from Excell spreadsheet and
transfer it to SQL Server
(by selecting *.xls file from dialog box, then hit transfer button)
Can you suggest something to me how I can accomplish it.
Thank you.

[John Timney (MVP)]

http://www.15seconds.com/issue/990513.htm

This shows you how to upload word docs directly from the browser into sql
server with no stops in between. You would only need to change the VB code
to accept excel extensions and you have a solution to start from.

Regards

John Timney (MVP)


Developer <devxchange@consultant.com> wrote in message
news:39203f4b$1@news.devx.com...
>
> Hi,
> I have a situation when I have to get all data from Excell spreadsheet and
> transfer it to SQL Server
> (by selecting *.xls file from dialog box, then hit transfer button)
> Can you suggest something to me how I can accomplish it.
> Thank you.
>