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
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
Bookmarks