I'm being sent many spreadsheets which contain data that needs to be imported into a database, but many of these sheets contain rows with values missing in a certain column.
Ideally these "malformed" rows would be excluded from the export (rather than removed afterwards from the database). Is there a way either to filter before export, or to populate a second sheet using something like this statement?
SELECT * FROM sheet1 WHERE [sheet1.column-reference] IS NOT NULL