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 PROTECTED]
