<cfquery name="" dbtype="ODBC" datasource="#session.dsn#">
  Select *
  into Newtable
  From Oldtable
</CFQUERY>


workings when ran in ACCESS 2000

-----Original Message-----
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 1:34 PM
To: CF-Talk
Subject: access table backup question

Hi All,
I want to backup couple of access tables every night, means just make a copy
of the table. Is there any easy solution to just copy the table instead of
me writing a script to grab all records and then insert to the table. I have
about 10,000 records in the table with about 10 fields.

Ketan Patel
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to