Re: Importing data from excel

ok thank you very much tom
have a nice day

--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


"Tom Moreau" wrote:

You don't need the SQL Server relational engine. Yes, SSIS is graphical.
In your case, you would have Excel as a data source and Oracle as a
destination. You would then create a data flow between them. Check out:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359.html

It's a very good text. SSIS is definitely worth learning.

--
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:DA4FF853-AB24-434A-AC10-FA87B4181B59@xxxxxxxxxxxxxxxx
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: Application Security based on SQL Security
    ... Ammar S. Mitoori ... IT Head QIMCO Co. ... Mobile: +9745378400 ...
    (microsoft.public.sqlserver.security)
  • Re: Application Security based on SQL Security
    ... Ammar S. Mitoori ... IT Head QIMCO Co. ... Mobile: +9745378400 ... Sometimes SQL Server throws not elegant messages to understand by the ...
    (microsoft.public.sqlserver.security)
  • Re: Importing data from excel
    ... SQL Server MVP ... Ammar S. Mitoori ... IT Head QIMCO Co. ... Mobile: +9745378400 ...
    (microsoft.public.sqlserver.tools)
  • Re: auditing users
    ... Ammar S. Mitoori ... IT Head QIMCO Co. ... Mobile: +9745378400 ...
    (microsoft.public.sqlserver.security)
  • Re: auditing users
    ... Ammar S. Mitoori ... IT Head QIMCO Co. ... Mobile: +9745378400 ...
    (microsoft.public.sqlserver.security)
Quantcast