Import from 'Filtered' Excel Spreadsheet

[franc75]

Hi.

I am trying to import a FILTERED Excel spreasheet into an access table.

One of the columns has numerous blank cells, so I am using a 'non-blanks'
filter to reduce it down to just the rows that contain info. These are the
rows I want to import.

By using the DoCmd.TransferSpreadsheet ... etc, it works perfectly, but it
still imports the blank rows as well.

Is there a way to import just the non-blanks ?

 

[John Nurick]

The simplest thing is probably to import them all and then use a delete
query to get rid of the ones you don't want, something like

DELETE FROM MyTable WHERE TheField IS NULL;

or

DELETE FROM MyTable WHERE TheField = "";