Create tables in Access 2000 using the SQL language

[Howard Brody]

Access uses SQL for its queries and you can select,
append, delete update or make a new table with queries.

Here's a sample for making a table of active employees
from your main employee table:

SELECT tblEmployees.EmpNo, tblEmployees.FirstName,
tblEmployees.LastName, tblEmployees.Active
INTO tblActiveEmployees
FROM tblEmployees
WHERE (((tblEmployees.Active)=Yes));

and, in Access, you need to end your SQL statement with a
semi-colon.

Hope this helps!

Howard Brody

 

[Murillo Augusto Santos Duarte]

Can I use the command Create Table from a Query?

-----Original Message-----
Access uses SQL for its queries and you can select,
append, delete update or make a new table with queries.

Here's a sample for making a table of active employees
from your main employee table:

SELECT tblEmployees.EmpNo, tblEmployees.FirstName,
tblEmployees.LastName, tblEmployees.Active
INTO tblActiveEmployees
FROM tblEmployees
WHERE (((tblEmployees.Active)=Yes));

and, in Access, you need to end your SQL statement with a
semi-colon.

Hope this helps!

Howard Brody





.