Make table

[mark]

Hi,
I am trying to make a table from code.
The same SQL is working in a query,
But when running the following in code - nothing happen
(not even an error message)

srtSQL = "SELECT Action.action INTO test FROM [Action]"
CurrentDb.Execute srtSQL

Is it not possible to create a teble from code?
Many thanks,
Mark

 

[Jeff Boyce]

Mark

SELECT ... INTO ... is equivalent to Access' Append query.

CREATE ... is equivalent to the Make Table query.

 

[Marshall Barton]

SELECT ... INTO ... is equivalent to Access' Append query.

CREATE ... is equivalent to the Make Table query.

Get some sleep Jeff or another cup of coffee ;-)

INSERT INTO ... is an Append query

SELECT ... INTO ... is a Make Table query

 

[Marshall Barton]

I am trying to make a table from code.
The same SQL is working in a query,
But when running the following in code - nothing happen
(not even an error message)

srtSQL = "SELECT Action.action INTO test FROM [Action]"
CurrentDb.Execute srtSQL

Is it not possible to create a teble from code?

Sure it's possible and what you have looks OK to me.

What makes you think it didn't do anything? If it's just
that you don't see the test table in the db window, try
using the RefreshDatabaseWindow method.

 

[Jeff Boyce]

Thanks, Marsh!

More coffee AND more sleep, obviously!

Jeff

 

[Jeff Boyce]

Mark

Please see Marsh's comments and disregard mine!

Jeff Boyce
(sleepy) <Access MVP>