Using ODBC, is it possible to import only part of an Oracle dataset into Access 2007? If so, how would I do that? I have an Oracle table with 6 1/2 million records, but I onoly want to see the first 500,000 records.

If anyone can advise on how to do this, I would sure appreciate it.

Thank you!

Using ODBC, is it possible to import only part of an Oracle dataset into Access 2007? If so, how would I do that? I have an Oracle table with 6 1/2 million records, but I onoly want to see the first 500,000 records.

If anyone can advise on how to do this, I would sure appreciate it.

Thank you!

Have you tried to use a pass through query where you would use Oracle syntax. You could include ... rownum <500001 in the WHERE clause.

You could try setting up an empty table in Access that corresponds to the structure in Oracle. Then using 2 recordsets and an INSERT INTO in a procedure, read the Oracle table(recset#1) and insert the record into the Access table (recset#2) and increment a counter. If the counter > 500000, stop reading from Oracle.

Some thoughts you may consider.

Thanks, jdraw,

No, I hadn't considered that! I have slim to none experience in using pass-thru queries, but will study up on them.

I appreciate your responding!

I have another question I should have thought about before.....

once I get the first 500,000 records, how would I then go about getting the next 500,000 records in a pass thru query? Like I said, I'm not familiar with pass through workings at all.

Thanks for any help, advice or comments!