Kick users out of Access via Excel VBA

[GeorgY]

Hello, I have VBA code, which in Excel, formats a worksheet and exports it to Access. I use an OLEDB connection with the database to do this.

My request is the following: before the formatted data can be exported to Access, I need some sort of code that will kick all users that may currently be using the database. Otherwise, the data will simply not get uploaded.

Can anyone help me out with that?

 

[DCrake]

Wouldn't it be more prudent to import the data from Excel into Access?

You have more control that way.

David

 

[GeorgY]

Wouldn't it be more prudent to import the data from Excel into Access?

You have more control that way.

David

It really makes no difference to me, as long as it is all done by code. How would I go about doing that?

 

[DCrake]

Would need to look at the layout of the spreadsheet before commenting on the best method of importing the data.