Blank data

Hi Jaz

Thank you for your question

The easiest method is to first import the spreadsheet in the normal manner into what will be a temporary table

You can then create a "Make Table" query that will exclude any blank rows. To do this;

Create a new query and then:-

1. Add in the temporary table
2 Include all the fields in the table in your query
3 In the criteria row, in each column, type the criteria Is Not Null
4 Click on the query type button on the toolbar and select "Make Table Query"
5 Give your new table a meaningful name
6 Run the query and click OK when prompted

You will now have a copy of the temporary table minus any blank rows. You can then delete the temporary table.

Hope this is useful

Regards

Stephen