Re: Importing data from excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

is SSIS a graphical tool ?

and if sql is not installed haw can i use it between Oracle and Excel ?
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


"Tom Moreau" wrote:

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: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • Re: Refreshing data from MSQuery OLAP Cube
    ... You can change it in Excel by changing ... through dangerous SQL to your SQL Server or invoke destructive UDFs. ...
    (microsoft.public.sqlserver.olap)
  • RE: Macro
    ... Then post the query results. ... My data is in an Excel file called ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ... VBA code in excel suddenly became un-compileable. ...
    (microsoft.public.excel.programming)
  • Re: Question for Joe Fallon--determining Data type
    ... then the data type for the column will be Text. ... means 255 characters max (that's a Jet limit). ... where MSDE or SQL Server is the main database (in these cases Jet ... Is 'Spreadsheet' an MS euphemism for 'Excel' or does it support other ...
    (microsoft.public.access.externaldata)
  • Re: Excel Sheets Opens Itself Again After ADO Query ! Please Help
    ... I'm using Excel 2003 so hopefully its similar to your setup. ... You should then be asked for the workbook to query ... You should see a SQL button now where you can edit the ... Hope this opens the discussion more. ...
    (microsoft.public.excel.programming)