[RESOLVED] Access - Import External Table

[MethadoneBoy]

Hi guys,

Is there any example of VBA code that will import a table from an external database into the current database (without using import/export specs)?

I'm thinking something along the lines of -

DoCmd.SetWarnings(False)
 
DoCmd.RunCommand <Import function>, <tablename>, <path to external db>...

[RobDog888]

You can perform an "INSERT INTO blah SELECT * FROM blah..." sql statement but your table will need to exist first. If your looking for the table creation too then you can use a function like so...

Public Sub ImportTable()
    Application.DoCmd.SetWarnings False
    Application.DoCmd.TransferDatabase acImport, "Microsoft Access", "D:\DB2ImportFrom.mdb", acTable, "Table1", "ImportedTableName", False
    'OR
    Application.DoCmd.CopyObject "DestinationDatabase", "NewName", acTable, "SourceObjectName"
    Application.DoCmd.SetWarnings True
End Sub

[MethadoneBoy]

That's exactly what I need. Thanks!