Control with VBA import from Excel

[hmanvel]

I have a table that regularly (several times a week) gets appended with data from an excel spreadsheet from an outside vendor. There are several selections to make, i.e. "import to existing table - import to new table" etc. and I would like to automate this process. Current setup has it importing to an existing table that then appends to a MYSQL table. There are calculated fields in the Excel spreadsheet that fill with zeros where no data is present, which causes import error messages. Works fine because Access filters out the garbage and only imports what I want. But I would like to suppress the error messages at the same time. Am I asking the impossible? Could someone suggest the code necessary to do this if it is possible?