Re: Copy/clone table
Execute SELECT * INTO NewTable FROM OldTable. Indexes will not be copied,
only data.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Brigitte" <poinsier@xxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:42f02c6f@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> How to copy a table schema and content in the same Access DB under another
> name, using ADO components and Delphi 7?
>
> Thank you
>
> Brigitte
>
.
Relevant Pages
- Re: Dropping a Database
... Thanks Vassiliev, we had tried this, but this gives an error stating that ... > Connect to master database and execute "DROP DATABASE XXX". ... >> Thanks in advance and with best regards, ...
(borland.public.delphi.database.ado) - Re: Impersonation code
... Best regards, ... > and that application will not execute on the other machines for the same ... >> Simply check out the user contexts of both applications and compare the ... >>> The impersonation of the user is successfully done. ...
(microsoft.public.dotnet.faqs) - Re: How to make and executable mdb file
... Note that MDE is distinct from runtime even though they can have same ... MDB file running on runtime can't be altered but can be by running a ... and deny all permissions except to execute the object to the public. ...
(microsoft.public.access.reports) - Re:
... I am reading a only. ... But what if I want read write and execute that file. ... Regards, ... >> Jatinder Singh ...
(comp.lang.python) - Re: Running Package From EM and Scheduler Problem
... Spadak ... >> Everything runs fine from designer, after each execute new file is ... >> If there is no file in destination folder new is created but after ... >> Kind regards, ...
(microsoft.public.sqlserver.dts) |
|
