Determine if Access Table exists using Excel VBA - XL 2010 - Windows 7

[cwunderlich]

Is there a way, in Excel, to determine if a table in Access exists? I have code which currently sets up a connection to Access and returns data to Excel from a Access table. However, if the table does not exist then I want the macro to do something else.

Thank you.

 

[CharlesChuckieCharles]

might be helpful if you pasted in the Macro (?)