0

Why do I get an error creating a temporary table with something even as simple as this:"CREATE TABLE #Results"? But this "CREATE TABLE Results" works. I thought we put # when we need to create temporary tables (Access), its like I've once done that. Help on that please?
Thanks!

2
Contributors
2
Replies
6
Views
5 Years
Discussion Span
Last Post by savedlema
1

As far as I know, Access does not support temporary tables. However, you can create a table on the fly with SELECT INTO as in

SELECT * INTO temptable FROM Customers WHERE Address  LIKE '*C*'

Just remember to drop the table when you are done.

0

Thanks Reverend. I decided to do it the long way. Create a table and then drop it. But, thank you so much.
I mark this solved.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.