Table transfer between databases

[plastikman808]

Hi - im now to the forum so firstly hello to everyone

I am trying to move a table called "03-01-FUNDVALDATA-02 : Holdings" from the Tools DB to MBLDB. I have tried the following based on what i could see using the help in the DB

Sub test()

DoCmd.TransferDatabase acImport, "Microsoft Access", _
    "C:\Documents and Settings\u46545\Desktop\Test Folder\01-Assets_DB\TOOLS.mdb", acTable, "03-01-FUNDVALDATA-02 : Holdings", "C:\Documents and Settings\u46545\Desktop\Test Folder\01-Assets_DB\MBLDB.MDB"

End Sub

I get an error saying its not a valie name? any ideas please?

 

[llkhoutx]

transferdatabase may not allow colons in a file name, "03-01-FUNDVALDATA-02 : Holdings".

Never ever use special characters in an Access object name.

 

[cpc]

There is a great post on "Access Naming Conventions" (of course in this Forum). When you get a chance check it out!!