ADO Copy Table to new MDB Help!

Ok I have tried several different approaches and nothing has worked! I
simply want to move records from one table to a new MDB file.

Can ADO do this or not?

code

Private Sub Command7_Click()

Dim loConnection As ADODB.Connection

Set loConnection = New ADODB.Connection


loConnection.Open "Provider='Microsoft.JET.OLEDB.4.0';" & _
"Data
Source='F:\DATABASES\NBIMIncome\NBIM_BE.mdb'"


lcSQL = "INSERT INTO t_NBIMFIprebal2 SELECT * FROM "
lcSQL = lcSQL &
"[F:\DATABASES\NBIMIncome\NBIM_BE.mdb].[t_NBIMFIprebal]"""




loConnection.Execute lcSQL, , adExecuteNoRecords


loConnection.Close
Set loConnection = Nothing



End Sub


Any help would be most appreciated.

.