Hello to all

I want to import excel file to sql server 2000 as table
without using Export/Import utility.

I have to use only asp/asp.net/vb.

Any help will be welcome.

Thanx in advance.

Dilip Singh Dodiyaa

If you do not want to use DTS then I fear you are asking in the wrong group
as we deal with DTS in here. That said you could use ADO.Net to open the
spreadsheet and go through it and enter the rows into SQL Server.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"dilip" <dilip_dodiya (AT) yahoo (DOT) co.uk> wrote