Imported Records Into Access From a SAS Generated Excel File

[jbi]

I generate a daily excel spreadsheet from a SAS query. This is usually about 89 records. When I import these records into an access database, I get 99 records. This includes the 89 good records and 10 blank records. Does anyone have an idea of what I doing wrong?

[JoeM]

If you open the Excel file, and hit CTRL-END, what row does it go down to?
If it goes 10 rows past the end, then the Excel file thinks there are 10 more records than there really are. That is probably just a matter of how SAS exports the data.

If you make one of your Access table fields required, then it should not import those 10 extra rows (they should error out).
Or, alternatively, you could create Delete Query and delete out the extra records after import (using "IS NULL" as the Criteria under one of your fields).

[jbi]

Absolutely right, Joe.

There are 10 extra "blank" records generated in the excel file geneated from SAS. I'm going back to the SAS code to try to correct the code.

Thanks.