CREATE TABLE/IF Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am receiving data extracts from a base. This data is going to be exported
to Excel spreadsheets; however, some extracts will have more than 65,000
rows. I would like to count the number of rows to determine if it is greater
than 65,000 rows. If the number of rows is greater than 65,000, I would like
to create a second table with all the rows above 65,000.

I have tried everything; however, I have not been successful.

Can somebody help me?

P.S.: I am working with MS Access.
 
perhaps create a temp table with 2 extra columns
one being and autonumber and one an identifier for the excel sheet

update the temp with the filenames using an iif() ie: an autonumber id <
65000 add a filename of 1 , 65-130 , 2 etc

use the temp table structure to define your outputs
 
Back
Top