Re: Linking MS Access DB into Oracle

Hello Ender

many thanx for your quick Help

but I need to Link "Access into Oracle" and not "Oracle into Access."

I need how to see Access Tables from my Oracle User.

I need how to make a SELECT in Oracle SQL Plus (for example) and get back the data form an Access MDB.

Cheers
Micha

EnderW <ender29_at_my-deja.com> schrieb in im Newsbeitrag: 8luvej$gu2$1_at_nnrp1.deja.com...
> Do u mean to link from access to an Oracle Database then here it is
>
>
> You can import or link data from ODBC databases such as Microsoft SQL
> Server, as well as other programs that provide drivers compliant with
> ODBC Level 1 to access their data files.
>
> Note If you chose the Typical option when you installed Microsoft
> Access, the SQL Server driver and ODBC support files will not be
> installed, and you will not be able to import or link from any ODBC
> machine data source. In this case, rerun Setup to install the SQL
> Server driver. Additionally, for each ODBC machine data source that you
> want to use, you must have the appropriate ODBC driver installed on
> your computer before you can import or link this database. For more
> information on installing and configuring ODBC drivers, click .
>
> 1 Open a database, or switch to the Database window for the open
> database.
> 2 To import tables, on the File menu, point to Get External Data,
> and then click Import.
>
> Show me
>
> To link tables, on the File menu, point to Get External Data, and then
> click Link Tables.
> Show me
>
> 3 In the Import (or Link) dialog box, in the Files Of Type box,
> select ODBC Databases.
> 4 In the Select Data Source dialog box, click the Machine Data
> Source tab to see a list of all ODBC machine data sources currently
> defined for the ODBC drivers installed on your computer. This list
> might include drivers that have not been tested and verified for use
> with Microsoft Access. Contact the driver vendor for verification.
>
> If you want to use a file data source, click the File Data Source tab
> and enter or browse for a file name. A file data source is useful for
> sharing ODBC driver connection information between different computers
> and does not require a Registry entry. For more information on file
> data sources, click or see the ODBC 3.0 Programmer's Reference Manual.
>
> If you want to define a new data source for any installed driver, click
> New, double-click the name of the ODBC driver, enter the data source
> definition (this will vary depending on the requirements of the ODBC
> driver), and then click OK.
>
> 5 In the Select Data Source dialog box, double-click the ODBC
> machine data source that contains the data you want to import or link.
> 6 If the ODBC data source that you selected requires you to log
> on, enter your logon ID and password (additional information might also
> be required), and then click OK.
>
> Microsoft Access connects to the ODBC data source and displays the list
> of tables that you can import or link.
>
> 7 If you're linking a table, select the Save The Login ID And
> Password check box if you want to save this information for the table
> in the current database and not require users to enter this
> information. If you leave the check box cleared, all users must enter
> the logon ID and password every time they open the table in each new
> session with Microsoft Access. Your SQL database administrator can also
> choose to disable this check box, requiring all users to enter the
> logon ID and password each time they connect to the SQL database. For
> information on how to disable the Save The Login ID And Password check
> box, click .
>
> 8 Click each table you want to import or link, and then click OK.
> If you're linking a table and it doesn't have an index that uniquely
> identifies each record, Microsoft Access displays a list of the fields
> in the linked table. Click a field or a combination of fields that will
> uniquely identify each record, and then click OK.
>
> Notes
>
> · After importing or linking an SQL database table, you can set
> field properties for the table. If you import a table, you might want
> to set a primary key for the table. For more information, click .
> · If you encounter an error while importing, linking, or using an
> SQL database table, there might be a problem with your account on the
> SQL database server or with the database itself. If you can't access an
> SQL database table, contact the SQL database administrator.
>
> · To edit a linked SQL database table, usually the table must
> contain a unique index on the server. If you want to edit a table that
> doesn't have a unique index or you want to edit an SQL view, you can
> create an index within Microsoft Access that the SQL database isn't
> aware of. You do that by creating a data-definition query, using the
> Create Index statement. Be aware, however, that the index must be
> created on a field or combination of fields in which each value is
> unique. If the field contains any duplicate values, all updates to the
> table will fail. To delete the index, use another data-definition
> query. For more information on creating such a data-definition query,
> click .
>
> · If the structure of an SQL database table changes after you
> link it, use the Linked Table Manager to refresh the link. For more
> information, click .
>
> In article <8luo8m$1ia5$2_at_news.okay.net>,
> "Mika" <Michael.Kurz_at_c-plan.com> wrote:
> > Hello
> >
> > How can I Link Tables from an MS Access (*.MDB) into an Oracle User.
> >
> > Or isn't that possible at all ?
> >
> > Thanx
> > Micha
> >
> >
>
> --
> Ender Wiggin
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jul 29 2000 - 00:00:00 CDT