Make Table and Access 2007

[Proposal Doctor]

Does Make Table work with Access 2007? I am running A12 SP2.

Here's the SQL I am trying with Northwind:

SELECT Employees.Company, Employees.[Last Name], Employees.[First Name] INTO
tblNewEmployees
FROM Employees;

Clicking Run doesn't create tblNewEmployees

Thanks.

David

 

[Allen Browne]

Make Table query works fine here in A2007 SP2.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...