Could anyone help me create a function to import tables?

I plan to tie to several Oracle based ( ODBC linked) tables, and use
Access97 as a reporting tool. I want to IMPORT the data from Oracle
tables, and rename them as Access tables for 2 reasons:
1) ensure that users cannot modify/delete Oracle data via Access
2) improve speed

I originally tried make-table and append queries in macros. There are
over 60 tables, and the list may grow. I don't want to clutter up the
database with over 120 unnecessary queries...

I would like to create  a function to do the updates using the following
logic:
1) If access table does not exist create the table
ELSE
2) Clear existing table and append all data. (In order to preserve
indexes, relationships, and table descriptions entered in Access)
The function could read information from a table to remap Oracle table
names as Access tables using Leszynski Naming Conventions.

Any suggestions for a better idea to do the same, or code snippets to
show me how to do this would be highly appreciated.

TIA

Sebastian

Hi Sebastian,

Sounds a bit involved :).  However, you can start by grabbing the ODBC
Reconnect code from my website (Tables section).  Using that methodology,
connect to a table, then use an Append Query to append the data to a local
Access table (Or a make table query).  After this, you can open the Access
Table and define all the information as you need it.  Access help has some
examples as well.

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:Could anyone help me create a function to import tables?
:
:I plan to tie to several Oracle based ( ODBC linked) tables, and use
:Access97 as a reporting tool. I want to IMPORT the data from Oracle
:tables, and rename them as Access tables for 2 reasons:
:1) ensure that users cannot modify/delete Oracle data via Access
:2) improve speed
:
:I originally tried make-table and append queries in macros. There are
:over 60 tables, and the list may grow. I don't want to clutter up the
:database with over 120 unnecessary queries...
:
:I would like to create  a function to do the updates using the following
:logic:
:1) If access table does not exist create the table
:ELSE
:2) Clear existing table and append all data. (In order to preserve
:indexes, relationships, and table descriptions entered in Access)
:The function could read information from a table to remap Oracle table
:names as Access tables using Leszynski Naming Conventions.
:
:Any suggestions for a better idea to do the same, or code snippets to
:show me how to do this would be highly appreciated.
:
:TIA
:
:Sebastian

:
:
:
: