Re: Connecting excel ro oracle database

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Wed, 17 Jul 2002 09:43:18 -0500
Message-ID: <nf0bjuot6vbg4k474udcsh0pktra1iujba@4ax.com>

If by connect you mean use Oracle data in the Excel spreadsheet, MSQuery can connect to Oracle using ODBC ( the 'get external data' menu option) or look into tools like OraXcel or SqlLink for MS Excel

rajXesh_at_hotmail.com (RK) wrote:

>"DA" <amunwa_at_hotmail.com> wrote in message news:<1026651306.99086_at_cache2>...
>> ...can anybody tell me how to connect an excel spreadsheet to an oracle
>> database...
>>
>> thxs in advance
>
>Look into creating a table in Oracle with ORGANIZATION EXTERNAL
>
>http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/statements_73a.htm#2093662
>
>You would probably have to save the Excel spreadsheet as CSV
>
>-- rajXesh

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Jul 17 2002 - 09:43:18 CDT