Re: creating a database through odbc?
Date: Sat, 21 Jul 2001 21:55:38 GMT
Message-ID: <ab87195e.0106200118.65e8c57_at_posting.google.com>
Unlike a few responses to your question, i'll try and give you an answer!
I'm NOT an ODBC expert but have seen it done before.
If you have MetaLink access on www.oracle.com, try doing a search on
ODBC Excel.
There are quite a few examples on how to achieve this assuming you
have the correct ODBC setup. Also, you can use Oracle Objects for OLE
(OO4O) instead of ODBC.
A bit worried about you saying 'you need a quick Oracle database' though. Unlike Access *eek!* creating a database in Oracle is not so quick. However, if you have a schema or user logon which allows you to create tables, you are halfway there.
Mark
kossack80021_at_yahoo.com wrote in message news:<G0uX6.13549$pb1.498297_at_www.newsranger.com>...
> I need a quick oracle database to test an app...
>
> not knowing that much about oracle, is it possible to create a file in excel or
> access and put it into oracle through odbc?
>
> else, I need a way of importing a simle file into oracle
>
> you can reply here or to kossack80021_at_yahoo.com
Received on Sat Jul 21 2001 - 23:55:38 CEST