Re: Importing data from excel

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: Importing data from excel
    ... SQL Server MVP ... Ammar S. Mitoori ... IT Head QIMCO Co. ... Mobile: +9745378400 ...
    (microsoft.public.sqlserver.tools)
  • Re: SQLite vs. SQL Server 2005 Mobile Edition
    ... You can sync with any ODBC database, ... Oracle also has their mobile database called OracleLite, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SQLite vs. SQL Server 2005 Mobile Edition
    ... Sybase's Ultralite has quite a few limitations, not the least of which is no ... As for Oracle's mobile product ... ... I shudder at all things Oracle. ... > Oracle also has their mobile database called OracleLite, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Free Oracle Server for intranet?
    ... Tony Rogerson ... SQL Server MVP ... Could you also please STOP PROMOTING sqlserver in an Oracle newsgroup. ...
    (comp.databases.oracle.server)
  • Re: Trusted (MLS) SQL Server?
    ... That is a rather big document, and I couldn't find the string "multi level" in there. ... Tibor Karaszi, SQL Server MVP ... > Microsoft offers an equivalent of Trusted Oracle? ... > have a rather large IIS/SQL2K web app written for a USAF security program ...
    (microsoft.public.sqlserver.server)