Wow, that seems like a lot of work just to import an excel spreadsheet. DTS
will take care of those connections for you so you don't have to worry about
it. it lists the named regions and sheets in the file, you just choose from
the dropdown the ones that you want and let it take care of the other stuff.

-----Original Message-----
From: Yukon DBA [mailto:[Email Address Removed]
Sent: Wednesday, October 02, 2002 10:45 AM
To: LazyDBA.com Discussion
Subject: Re: Importing data from Excel Sheet

Try this:

SELECT .*
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\*.xls';'';'', <sheet Name$>)


----- Original Message -----
From: "Farnsworth, Dave" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, October 02, 2002 8:44 PM
Subject: RE: Importing data from Excel Sheet


Use SQL Servers DTS function. You can import just about any type of data
with it. It works really nice.

Dave

-----Original Message-----
From: Parag Kulkarni [mailto:[Email Address Removed] Wednesday, October 02, 2002 10:07 AM
To: LazyDBA.com Discussion
Subject: Importing data from Excel Sheet


Hi everyone,

I need to import data from Excel 97-2000 file to one
of the tables in the database on SQL 2000.
Can somebody tell me how to do it.I tried by building
a query but it gave me some syntax error though after
parsing the query , it came out as Valid.
Thanks,
Parag

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page