Before I can import data from a .csv file into a database, many columns
need to be formatted or values need to be replaced. Previously, this
manipulation used to be done manually and the import worked fine. I
have since recorded a macro to automate all the changes. But now the
import seems to be finding lots of empty records at the end and I have
to kill the import. How to save the .csv file so that blank rows are
not included in the import?