If its a access DB then just open the DB and copy and paste the table. Dan
-----Original Message----- From: Andy Hayman [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 15:18 To: ActiveServerPages Subject: RE: Cloning Tables with SQL At the mo it is Access, so I could use Create to create the table and set the structure Then select into to fill it? Excellent Thanx > -----Original Message----- > From: David L. Penton [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 14:49 > To: ActiveServerPages > Subject: RE: Cloning Tables with SQL > > > With MSSQL, use DTS > > You can also do: > > SELECT * INTO newTable FROM oldTable > > in many RDBMSes > > You can also generate the CREATE table and INSERT statements > (using a language of your choice) > > David L. Penton, Microsoft MVP > JCPenney Application Specialist / Lead > "Mathematics is music for the mind, and Music is Mathematics > for the Soul. - J.S. Bach" [EMAIL PROTECTED] > > Do you have the VBScript Docs or SQL BOL installed? If not, > why not? VBScript Docs: http://www.davidpenton.com/vbscript > SQL BOL: http://www.davidpenton.com/sqlbol > > > -----Original Message----- > From: Andy Hayman [mailto:[EMAIL PROTECTED]] > > Hey all > > Is it possible to "clone" or copy an existing table, basicly > I want to copy a table with its structure and data on the > fly, I know I can INSERT a table then copy the data by > reading it then writing it but is there a copy or clone command? > > > --- > Andy Hayman > Kensington Computers > Internet & Computers Systems Consultant > Web <http://www.ken.co.uk> > Email <mailto:[EMAIL PROTECTED]> > Telephone 020 7835 1282 > Fax: 020 7373 6900 > > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
