-
How to transfer data from Oracle 8i to MS Access
Does anybody can let me know how to transfer data from Oracle 8i to MS Access 2000 or viceversa.
-
Oracle to Access Copy
Create a Link from your Access Database to your Oracle Database
Enter something like this to copy data from the Oracle Database to
an Access Table.
This is an example from a Death Database I work with.
SELECT * INTO
FROM H72DEATH_H72DEATH
WHERE ((([H72DEATH_H72DEATH].[DEATH_BOOK_YEAR])=1994) And (([H72DEATH_H72DEATH].[DEATH_STATE])=3) And (([H72DEATH_H72DEATH].[DEATH_COUNTY_NAME])="MARICOPA"));
Hope this helps.
-
Oracle to Access Copy
Create a Link from your Access Database to your Oracle Database
Enter something like this to copy data from the Oracle Database to
an Access Table.
This is an example from a Death Database I work with.
SELECT * INTO Access_Table
FROM H72DEATH_H72DEATH
WHERE ((([H72DEATH_H72DEATH].[DEATH_BOOK_YEAR])=1994) And (([H72DEATH_H72DEATH].[DEATH_STATE])=3) And (([H72DEATH_H72DEATH].[DEATH_COUNTY_NAME])="MARICOPA"));
Hope this helps.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|