+ Reply to Thread
Results 1 to 2 of 2

Make a copy of a table

  1. 11-19-2020, 04:52 AM #1
    Jan7219
    Jan7219 is offline
    Registered User
    Join Date
    11-10-2020
    Location
    London
    MS-Off Ver
    365
    Posts
    11

    Make a copy of a table

    Hello All,

    I would like to create a copy of a table. The code I got is below, but it is not working. Please help!

    /P 


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 12-07-2020, 03:22 PM #2
    ranman256
    ranman256 is offline
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: Make a copy of a table

    you dont use a recordset on an action query.

    docmd.runsql "SELECT * INTO TEST_ FROM TEST"
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ms Word make an extra copy of the table I have linked from Excel
    By lianweiling in forum Word Formatting & General
    Replies: 1
    Last Post: 02-10-2018, 02:07 AM
  2. How to create a new modified connection when I make a copy of a pivot table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-26-2016, 04:59 PM
  3. Grabbing values from one table based on a certain condition to make another table.
    By Adrian.L in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2016, 12:49 PM
  4. Make conditionally sized dynamic table (data table)
    By myersac in forum Excel General
    Replies: 0
    Last Post: 09-17-2014, 03:23 PM
  5. How to make Excel look at table 1 and pick a value from table 2 based on condition.
    By nlpman in forum Excel General
    Replies: 6
    Last Post: 03-11-2012, 09:28 AM
  6. PLEASE DELETE this post
    By -EE- in forum Excel General
    Replies: 0
    Last Post: 02-22-2012, 07:46 PM
  7. to make a pivot table to work with an adjoining table
    By byronova in forum Excel General
    Replies: 2
    Last Post: 09-06-2009, 10:47 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1