Member Avatar for savedlema

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
  • 378 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by savedlema
Member Avatar for Reverend Jim

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.

Member Avatar for savedlema

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.