Create Temp Table in Access
Dear All,
I want to create temp table in access, but not the way in SQL server. I did it in SQL server was Create table #tableName .... etc... but it does not work in Access... does anyone know any other solution?
thanks
Yolip
[250 byte] By [
yolip] at [2007-11-18 22:11:54]
# 2 Re: Create Temp Table in Access
Do it the same way as you would in sql server, but do NOT use the #
CREATE TABLE tmpTable (ID Integer, Field1 varchar(255)) etc etc
Don't forget to explicitly drop the table when you've finished - I don't think Access actually has temp tables, so you have to create a normal table, then drop it when you've finished with it.
