Import Oracle Database to MS Access (1 Viewer)

[wbuttano]

If I have Oracle Database on the Server, and I want to import Table to MS Access with a condition, etc. the TABLE on Database have 4 Field, But I want to import for 2 Filed . How can I connect to the Database and Import 2 field to MS Access
Thank you
Wiwattana B.

 

[Chris RR]

Have you considered just linking to the Oracle table? That way you don't need to worry about keeping the two tables synchronized.

Otherwise, link to the table, write a SQL query to select your records and fields, and use that query as the source of a make table query to create the Access table.

OR get your DBA to build you a view in Oracle that just contains what you want, and either link to that view directly or use that view as the source of a make table query to load your Access table.