Best way to output list of records from database
Howdy.
I'm using an access database to record some stuff.
There's about 10000 records in the database. Each record has about 30 fields.
I'm using my own numbering system (because I dont trust Access). The RecNum field is a unique numeric field that says what record number this record is.
So for viewing things etc. I use Select * From CompanyInfoTable Where RecNum = n.....
And its going great.
But now I have to write a piece of code to make reports.
Its going to be outputting fields from various fields.
And its going to have to go through each record.
I was thinking of just storing what the total number of records is as a long, then using a do loop :
Do Until i = totalRecordNumber
' ...
Loop
And then looping thru each record and saving it to the file.
Is there any better way of doing this ?
I just want to pick out say 4 or 5 fields from each of the 10,000 records and put that into a file.