Results 1 to 2 of 2

Thread: copy table

  1. #1
    Join Date
    Oct 2005
    Posts
    23

    Unanswered: copy table

    My way of copying table structure only does not work with linked table.it does copy the table but not structure only,and with everything with it.Coukd i avoid that and copy a linked table structure only ?
    DoCmd.TransferDatabase acImport, "Microsoft Access", CurrentDb.Name, acTable, "tblClients", "tblObsoleteClients", True

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Macro

    The best I can find is to use VBA to call a macro and use the docmd. transferdatabase acImport.......

    There is an option to import structure only.

    Hope that helps.

    :-)Stu
    --If its free, take it for what its worth!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •