Importing Excel Data

[Guest]

I created a Transfer data macro to import data from excel. I know some of the data could create an import error table and so in my macro I use deletobject to delete the error table. When I run the macro I get the message: Action failed, Macro name-Transfer data, condition-True, Action name-Deleteobject importerrors. When I close the acton failed message box and check the table for data, there is no date there. Anyone have an idea what is causing the data to not transfer. I have set up several similar macros for other databases I use and I have no problem except with this one
Than

 

[Ken Snell]

The error box that you're getting seems to me to be related to an error that
occurs when ACCESS tries to delete the importerrors object. I'm not sure
what you mean by the table has no data -- do you mean the table that should
get the data that can be imported?

It sounds as if the file from which you're trying to import the data doesn't
have any data to import?

--
Ken Snell
<MS ACCESS MVP>

I created a Transfer data macro to import data from excel. I know some of

the data could create an import error table and so in my macro I use
deletobject to delete the error table. When I run the macro I get the
message: Action failed, Macro name-Transfer data, condition-True, Action
name-Deleteobject importerrors. When I close the acton failed message box
and check the table for data, there is no date there. Anyone have an idea
what is causing the data to not transfer. I have set up several similar
macros for other databases I use and I have no problem except with this one.