File import, warning table already exists. How?

[NDK]

Hello all,
Using VBA, I'm importing a .txt file into a table the name of which is derived from part of the .txt file name. I want to warn the user if a table of that name already exists.
How do I inspect the current database for an existing table of the same name?

Many thanks,
ND

 

[larryww]

bAlreadyExists=false
On Error goto Myline
(attempt to open it)
on error goto 0
if bAlreadyExists then
msgbox ...
exit sub
endif

Myline:
bAlreadyExists=true

 

[NDK]

Nice
Thanks for your help.

ND

 

[larryww]

You're welcome. Glad it worked out.

I appreciate your thanks, because I spend real time on some of these replies, and often - real often - never hear a peep - nada. A simple acknowledgement or later followup as to the outcome is always worthwhile. (Yours wasn't too bad, though, and I'm happy to help out).

It needs a Resume Next statement at the bottom of my prior post, too