Re: Access Help

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/24/04 

Date: Wed, 23 Jun 2004 22:06:09 -0400

Hi,

I think simplest way is to use SELECT INTO sql statement. It will create the
table and copy all the data into it. Only one issue - it does not copy
related indexes.
You query would look like

SELECT * INTO MyNewTable FROM MyOriginalTable 

-- 
Val Mazur
Microsoft MVP
"Senthil" <Senthil@discussions.microsoft.com> wrote in message 
news:725534B7-67A5-433C-8062-2AF855BFF263@microsoft.com...
> hi
> would like to know how to copy a table in a access file and paste the 
> table in the same access file with a different name. with the help of a VB 
> code...
>
>
> Thanks
>
>
>