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" <fa******@yahoo.com> wrote in message
news:13**************************@posting.google.c om...
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