Filter Data on Import

[ijswalker]

Hi,

Does anyone know of a way to filter a file on import into Access. I have a CSV file and I want to be able to filter the report to exclude records with a zero value when I import into Access.

Thanks

Ian

 

[gemma-the-husky]

you need to import to a temporary table, massage the table to remove the data/tidy it up, then load the table to your actual database