Access 2000 / Import Data

A

Abay

I am importing data from excel files and find that I have extraneous blank
lines/records. Have tried to delete them without success, they look blank
but when I run a query to identify records with data < "a" for example,
or = " " (to spaces) none of the records are selected. My question is how
to identify the contents of these fields and how to delete the records.

Any help would be much appreciated

Abay
 
V

Van T. Dinh

Are you trying to delete these blank Records / rows in the DatasheetView of
the Table AFTER import or in Excel spreadsheet before importing into Access?
 
A

Abay

Thanks for your reply & I am using delete query in Access after the import
procedure.

Abay
 
E

Elise

I'd try one of two ways.

Filter the records in the datasheet view for null in all fields.
Select the results using ctrl-A
Hit delete.

If the filter doesn't work highlight all the fields in the table and sort
them.
All the blank records will be at the top of the table. Select them manually
and delete them that way.


Elise King-Lynch
 
Top