type mismatch?

[zhongwei]

I'm writing code to copy a table(named table1) to another database(C:\db8.mdb),and new table's name equal to variable T
the coding is like:
Dim T
T = "1234"
DoCmd.CopyObject "c:\db8.mdb", t, "acTable", "table1"
every time I run it the error message pop up saying"type mismatch".I check the instruction of Docmd.copy everything looks ok,Where is the problem?

Any reply will be greatly appreciated.

 

[JimHorton]

zhong,
acTable is a Constant, don't use quotes around it, that should do it.
--Jim