Import table into database Access 2007

[Manuelauch]

I use code: DoCmd.TransferDatabase acLink, "Microsoft Access", _
stSourceFullPath, acTable, stSourceTable, stNewTable, False
but this only works when the source database is .mdb.

What would be the codes when the source database is .accbd?

 

[Tom van Stiphout]

On Thu, 15 Apr 2010 17:43:02 -0700, Manuelauch

I just tried and it works fine for me. Are you getting any errors?

-Tom.
Microsoft Access MVP

 

[LarryE]

It should be .accdb not .accbd. You reversed the last two letters in the
extension.

 

[Manuelauch]

I am sorry for my late repsonse, but it works now. I do not know what was
the problem