My MS Access database has DSN links to Oracle tables, and I can grab records in the Oracle tables and put into Access tables. However, the size of the database is much bigger than that without the links. I wonder if anyone can show me an example how to create a DSN-less connection to the tables and transfer data in the recordset into my Acccess tables.

Thanks in advance for your help!