How to import excel data to tempdb

I am using SQL 2000. I would like to import an excel file to a tempdb
table (using # or ## methods). Can someone help me with it? I
apprecite it.Create a Linked server to the Excel spreadsheat. You'll find examples in
Books Online. See sp_addlinkedserver and sp_addlinkedsrvlogin in SQL Server
Books Online.
After configuring the linked server, I'd simply create the table in tempdb
and do an insert into the table, using the "INSERT INTO MyTable (<Column
list> ) SELECT <Column list> FROM LinkedServer...TableName" syntax.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"fl" <fzl20@.yahoo.com> wrote in message news:40EAF34B.555AE2DC@.yahoo.com...
> I am using SQL 2000. I would like to import an excel file to a tempdb
> table (using # or ## methods). Can someone help me with it? I
> apprecite it.
>

How to import excel data to tempdb

I am using SQL 2000. I would like to import an excel file to a tempdb
table (using # or ## methods). Can someone help me with it? I
apprecite it.
Create a Linked server to the Excel spreadsheat. You'll find examples in
Books Online. See sp_addlinkedserver and sp_addlinkedsrvlogin in SQL Server
Books Online.
After configuring the linked server, I'd simply create the table in tempdb
and do an insert into the table, using the "INSERT INTO MyTable (<Column
list>) SELECT <Column list> FROM LinkedServer...TableName" syntax.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"fl" <fzl20@.yahoo.com> wrote in message news:40EAF34B.555AE2DC@.yahoo.com...
> I am using SQL 2000. I would like to import an excel file to a tempdb
> table (using # or ## methods). Can someone help me with it? I
> apprecite it.
>