Thousands of empty spaces

[DTomm]

I am having a problem with empty rows in a table. Someone else downloads the information into a specific table. She is using Monarch (which I am not familiar with) to put the information on an excel spreadsheet to import to the table. I am the one who runs the reports. There are always hundreds of thousands of empty spaces. So it takes extremely long to run the reports. It is becoming a major hassle. Is there anyway that I can delete these rows quickly? Or possibly set some parameter to not download any empty rows? Right now I am manually deleting these rows. I tried compacting the database but it didn't remove the empty rows in the table. Please help, I am pulling my hair out already trying to fix this.

 

[tweetyksc]

I feel your pain

I'm having the same problem; but, rather than fix it after the fact I think it would be better to fix it prior to import.

I'm importing a file saved to a .csv format from Excel (because Excel stinks when you try to import). It is showing 28,461 records in the imported table, out of which 10,211 are actual records, the rest blank.

I was able to see why this was doing it because in the original Excel file, if I hit Control + End to go to the "end" of the file, it goes to line 28,462.

Since I format this Excel file with a macro before saving it to csv, I'm going to attack it from that angle somehow, because obviously it thinks 28,462 (28,461 records) is the end of the file.
Anyhow, I'm posting this in case it helps somehow. In my case, I can put in the formatting macro to recognize the "correct"end of file, but I'm not sure in your case.

 

[Nouba]

You could try using (make a backup first) a delete query. Put in the where clause your fieldname(s). All records which fullfill the condition (are empty) will be deleted.

DELETE *
FROM MyTable AS Q
WHERE Q.EventDate Is Null

hth nouba