Does anyone know how to create a temporary table??

[TheCrusher]

Can anyone suggest the best method to create a temporary table? I would rather not use the (SQL) Make Table / Drop Table statements. Instead, create a table in which data can be temporarily stored in while my code runs, kind of like a table stored in a variable????

Thanks
Doug

 

[Drevlin]

Perhaps just place the information into an array?

Are you saying you have a reason to not create a table using ADO/DOA, fill the table, and then destroy the table when you're code is completed?

 

[TheCrusher]

We only need the table temporarily and when we create and drop the table(s) everytime the code runs, our database increases in size drastically. I ran our code 3 times and our database size went from 380K to 780K. Compact and repair brought it back down to 380K. Thanks for your idea and any more suggestions would be greatly appreciated.

 

[Drevlin]

Well this may be a little bit extreme... but you could set up a temporary database, create the table inside that database, link to it run your program and then destroy the temp database.

That would solve your problem and not affect the size of your original database.

 

[Pat Hartman]

You may not need to make a temporary table at all. Queries can be used interchangeably for tables in almost all situations.