Importing From One Databse Into Another

Hello,

I need to import the data from one database into another everytime a form opens, I have some code which works:

Function GrabAccessTable()
DoCmd.TransferDatabase transfertype:=acImport, _
databasetype:="Microsoft Access", _
databasename:="\triggerwwwroot$AW@RDAW@RDOnline.mdb", _
objecttype:=acTable, Source:="Main", _
destination:="Table", structureonly:=False
End Function


The problem is that it won't surrently write it into an existing table, I want it to write into a table called Table (stupid choice of name I know....) but instead it creates a new table calle Table1.

Thanks

Richard