creating a table in sql

[bplus]

Hi,
I ve got an access db thats attached to a java application.
I need to be able to create a temporary table that stores a result set, its necessary to do this as the java app needs to perform lots of repeated operations on this temp table.

I was think something like this would work:

DROP TABLE tempResults
CREATE TABLE tempResults
AS
SELECT col1, col2, col3 ....
FROM orginalTable

So i tried this:

Create table temptable AS
SELECT education,
FROM supermarketTable;

but it doesnt work, access complains about syntax error in create statment.

Could anyone give me some pointers?

thanks in advance!

 

[WayneRyan]

B,

Try:

Select * Into NewTable From OldTable;

Wayne

 

[bplus]

thanks, ill give that a go.