Unanswered: Third party tool to Export data to access
Hi, I was wondering if there is any existing third party tool (preferebly free) that can export selected records from an Oracle database into microsoft access.
If this tool is a web app, its even better =)
Sure. Create a link to link from Access to the Oracle table. Create a make table or append query in access, filter the query and allow it to make or append the Oracle records to Access. If you no longer need the linked table then delete the link.
You could also create a SQL Pass Through Query in Access to connect to Oracle and get the data. You could use that pass through query as a basis to populate the Access table.