Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

copying a linked table and contents


  • Please log in to reply

#1
DanSimp

DanSimp

    New Member

  • Member
  • Pip
  • 4 posts
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.

  • 0

Advertisements


#2
dsm

dsm

    Member

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

Good Luck
David
  • 0

#3
DanSimp

DanSimp

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
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?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP