Check to see if Database has been created

[Dave31]

Ive come across some code which will create a database in Access from Excel which will copy all the data from the excel spreadsheet to a table in the database. The database is created and named the same name as the excel spreadsheet, the only problem with this code is that when it spots that the database has already been created, it throws an error.

Here is the code

Please Login or Register  to view this content.

Now i want to to look to see if the database has been created, if it has, run the above code to create it, if it is already there, skip the creation part and continue to the next part that enters in the required data (not shown above)

Any ideas how to get Excel to check if the database has been created in Access?

Many Thanks

Dave

[royUK]

This is untested but try adding an error handler

Please Login or Register  to view this content.

[Dave31]

Ah, that works great

Thank you very much

Dave