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!
savedlema
17
Junior Poster
Recommended Answers
Jump to PostAs 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.
All 2 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
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.
savedlema
17
Junior Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.