Quick question - Transfer Excel to Access

[101287]

When I execute a macro to load an excel file spreadsheet, it generate an error table name ....error.

Is there anyway that I could read the objects and search for the name and automatically (with a macro) and delete it.

Please advise and thank you for the guidance.

Luis

 

[SkipVought]

Hi,

Search & Destroy in Excel, based on the name of what kind of object?



Skip,

_[red][/red]

 

[101287]

Don't understand your answer. I thought that I can use the DeleteObject method or the Drop command in sql. However, don't know how to start with the VBA code.

Probably I did not provided enough information or detail in my question.

Thank you for your time and assistance.

 

[SkipVought]

Are we talking about DATA or OBJECTS???

I thought that there was an Excel object that you, for some reason, want to DELETE.

"Is there anyway that I could read the objects and search for the name and automatically (with a macro) and delete it."

I dunno, I thought that it might shed some light on the issue if we knew what kind of object we were going to delete; you know, it has a reference path and must be properly quallified etc.

Also, what line of code is generating this error?

Skip,

_[red][/red]