Query by record position in table

[DaveC]

Is it possible to retrieve records by their position within the table? For instance, if I wanted the first 10,000 records or the second 10,000 records etc.



Thanks.

[burrina]

You do so by setting the Column Variable. I don't understand the reasoning behind this though!

[June7]

burrina, what is Column Variable?

An Access table is not like Excel spreadsheet. Basically, records do not have a 'position' in table. Think of table as a bucket. And records like lego blocks dropped in bucket. If you want the records/blocks displayed in a particular order, must apply sort criteria.

[DaveC]

My issue is that I have a very large table in an Oracle database that I want to copy into Access, but that will result in a file that's bigger than Access can handle. I figured that I could break the table up into smaller pieces by doing make table queries on some set of criteria, but there is no row ID or autonumber column in the table that I can select on. Don't know how I'm going to do this, looking for ideas.

[June7]

Need some criteria - a date or alpha grouping.

[ssanfu]

Can the Oracle table be export as a CSV file?
Then you could use VBA to open the CSV file and import the records until you reach a max number - row count, file size, whatever.
Once the max is reached for that table, start adding records to a BE.

Is the Oracle table a "flat file" type structure or is it part of a normalized structure?

[DaveC]

Can't export a CSV from Oracle. Only a binary output file. It's a flat data table. I can select records by date if I link it with another table that has a date field and a column that's common to the one I'm trying to split. I will go that route, thanks.