I am unable to convert a large file into ascending view.

[rgrstvr]

The file was converted from excel. It is in Datasheet view. I select the first column and clip on the Ascending choice under the Home Tab. It works but leaves a large gab of blank rows. I go to the Database Tools tab and check Compact and Repair Database. The file returns to the original unorganized list.

[John_G]

You should use an update query to delete all the blank rows from the table.

Delete all the rows where some field you know is required is null (a row ID or something like that)

John