-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Back up, essentially, means copy. Therefore, link the Oracle tables to
the Access .mdb file. Use an INSERT INTO query to copy the data from
the Oracle table to the Access table.
INSERT INTO AccessTable (Column1a, Column1b)
SELECT Column1, Column2
FROM OracleTable
WHERE <criteria, if any>
The query would be the documentation of how the data was copied.
Read the Access Help articles on linking tables and the INSERT INTO
statement.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIeA5IechKqOuFEgEQKOoACaA2Sj1imrOC+raKHB+TaeYP aw7e4AnRA7
Nkxi3YDVyvK+93xhHoethTkO
=2dUW
-----END PGP SIGNATURE-----
Pavs wrote:
This may not be the place to ask however i am looking for resources on
how i may document data I am backing up from an oracle database to MS
Access.
Basically I have my oracle database and i have an Acess database.
I have to back up 3 tables from oracle into access.
I have no idea how i would document this.
I want to say Columns 1, column 2 from table A in oracle will be
backed up to Column 1a and Column 1b in Access.