Re: Importing data from excel

Your package can create the table, if necessary. Otherwise, it can assume
the table exists. Yes, you map the source columns to the destination's
columns. You can get fancy and have the data flow cleanse the data, add
calculated columns and the like. It's very powerful. For good tips, check
out www.sqlis.com.


--
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:54899B9A-4B51-40F9-82AB-490F01B66334@xxxxxxxxxxxxxxxx
i have 1 last question, when you sat source and destination my mind
understand that the process will create new table in oracle and full it
wiith
data from excel but what if there is an existing table already in oracle can
i do mapping in columns between the two tables ?

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


"Pure Heart" wrote:

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
    ... 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: Importing data from excel
    ... understand that the process will create new table in oracle and full it wiith ... IT Head QIMCO Co. ... Mobile: +9745378400 ... SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
Quantcast