Re: Importing data from excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

SSIS comes with SQL Server at no extra charge. You can pump between Oracle
and Excel without having to go through any intermediary. Why pay for a 3rd
party tool?

--
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:901FA1A3-81C2-4818-B33B-3C84A70A0CFF@xxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: SSIS and unicode data types
    ... my varchar columns are at most 50 characters. ... destination column in the SQL database destination is only varcharor ... How do I get an Excel column of datatype ... It left SQL Server as a VARCHAR and went into Excel, ...
    (microsoft.public.sqlserver.dts)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Excel 2007 connection
    ... The Feature pack also contains the SQL Server Client ... You should install it. ... so I installed them both as I do for Excel 2003. ...
    (microsoft.public.sqlserver.olap)
  • Re: Trasfer data to SQL Server
    ... Do you know how you would execute the DTS package from excel? ... Currently Using SQL Server 2000, ... This will place a SQL Server icon onto the DTS ...
    (microsoft.public.excel.programming)
  • Re: Newbie: Update From Excel
    ... Add an Excel Connection. ... Point it to your SQL Server ... Now create a transform data task coming from the Excel Spreadsheet to the ...
    (microsoft.public.sqlserver.dts)