table deletions

[Archer]

Hello,

i have access 2003 and trying to place t-sql code into access.
That for sure will not work, just copy and pasting,

does anyone know why, when i create a into statement access informs me
the table I want to put into will be deleted? eg: select xxxxx
xxxxx
into table2
from table1.
I would appreciate any help i can get

Thank you

[Larry Linson]

Re: table deletions

Access does not use T-SQL. Transact SQL is for Microsoft SQL Server. Access
has its own flavor of SQL, and the differences are not all minor ones. The
easy way to start learning Access SQL is to look in Help, and to create
Queries using the Access Query Builder and then switch to SQL view.

Larry Linson
Microsoft Access MVP



"Archer" <farid550@yahoo .com> wrote in message
news:1307cef1.0 408050740.3394e 2b6@posting.goo gle.com...[color=blue]
> Hello,
>
> i have access 2003 and trying to place t-sql code into access.
> That for sure will not work, just copy and pasting,
>
> does anyone know why, when i create a into statement access informs me
> the table I want to put into will be deleted? eg: select xxxxx
> xxxxx
> into table2
> from table1.
> I would appreciate any help i can get
>
> Thank you[/color]

[Anne Nolan]

Re: table deletions

Try
Insert into Table2 Select Blah1 Blah2 from table1.

Your syntax is for creating tables, not appending to an existing one.

"Archer" <farid550@yahoo .com> wrote in message
news:1307cef1.0 408050740.3394e 2b6@posting.goo gle.com...[color=blue]
> Hello,
>
> i have access 2003 and trying to place t-sql code into access.
> That for sure will not work, just copy and pasting,
>
> does anyone know why, when i create a into statement access informs me
> the table I want to put into will be deleted? eg: select xxxxx
> xxxxx
> into table2
> from table1.
> I would appreciate any help i can get
>
> Thank you[/color]