By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,223 Members | 1,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,223 IT Pros & Developers. It's quick & easy.

How to document backing up data to an Access Database

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----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.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.