[DanSimp]

I wish to copy the structure and the contents of a linked table (stored externally to access) into a new access table

The VB below sadly doesn't do the trick:
DoCmd.CopyObject , "NewTableName", acTable, "SourceTableName".

It only makes a mirror of the linked table. Anyone got any ideas?

Edited by DanSimp, 24 June 2005 - 02:19 AM.

[Advertisements]

The simpletest and most effective way would be to create a make table query with the linked table as the source.

Good Luck
David

[dsm]

The simpletest and most effective way would be to create a make table query with the linked table as the source.

Good Luck
David

[DanSimp]

Thanks for your reply, but I was hoping this could be done simply in VB, as the whole process is to be automated.

BTW I've managed to write some VB code that goes through the table row by row and inserts the contents into a new local table, but I was hoping for a one linner in VB really rarther than a 7 linner.

Does anyone else have any ideas?