How to document backing up data to an Access Database

[Pavs]

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.

Maybe i need to visit a visio forum?

Has anyone had similar exeperiences?

Does anyone know of any resources on the net?

[MGFoster]

Re: How to document backing up data to an Access Database

-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIeA5IechKq OuFEgEQKOoACaA2 Sj1imrOC+raKHB+ TaeYPaw7e4AnRA7
Nkxi3YDVyvK+93x hHoethTkO
=2dUW
-----END PGP SIGNATURE-----


Pavs wrote:
[color=blue]
> 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.[/color]