EXTRACT DATA FROM EXCEL

  • Thread starter Thread starter demps77
  • Start date Start date
D

demps77

Hi, I was hoping someone could help, I have an excel spreadsheet with
about 400 records on it but there is an empty line between every
records so there are 800 lines, is it possible to exctract these empty
lines of data or import just the data into a new spreadsheet or
database?
 
import the data into an Access table. pick a field in the table that has
data in every one of the 400 records. then write a Delete query, as

Delete * FROM TableName
WHERE FieldName Is Null;

replace TableName with the correct table name, of course; and replace
FieldName with the name of the field you picked earlier.

hth
 
Back
Top