Re: Importing data from excel



thanks

but if i use also oracle and excel dont you think third party tool is easer
such as altova databasespy ?
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


"Tom Moreau" wrote:

Use SQL Server Integration Services (SSIS), using Excel as the source and
SQL Server as the destination. Alternatively, you may be able to create a
linked server to the Excel workbook and then use T-SQL to pull the data.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Pure Heart" <PureHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0895572-AE23-4C3A-BFC6-93CB00049704@xxxxxxxxxxxxxxxx
I was wondering do SQL Server 2005 has a built in tool to import data from
excel table to a sql table ?
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643



.