How to make a newly created table overite existing table in access?

peter_z

Board Regular
Joined
Feb 27, 2011
Messages
87
Hey guys, using this code:

Dim strUser As String
Dim strWorksheet As String
strUser = Environ("Username")
strWorksheet = "STATEMENT"

'Instantiate the connection object and specify connection properties
Set oCon = CreateObject("adodb.connection")
oCon.Provider = "Microsoft.ACE.OLEDB.12.0"
'Open the connection
oCon.Open "C:\data\database.mdb"
'The spreadsheet data starts on the 7th row,
'so ignore the previous 6 rows by starting on the 7th
Dim IntRow As Integer
IntRow = 1
strSql = "CREATE TABLE" & " " & strUser & " " _
& "(Client_name CHAR);"
Debug.Print (strSql)
'Execute the sql command
oCon.Execute strSql
oCon.Close
Set oCon = Nothing

Does anyone know what changes I need to make to this so that the table overites the existing table when used more than once?

Cheers!
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top