If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results. This method won't work in SQL Server, but Microsoft's Trans ...

Figure A Image: Microsoft. The new virtual tables wizard makes it simpler to create a live connection to enterprise data sources like SQL and SharePoint in Power Apps.

Then they're there, no one knows it, and you can use the full functionality of Access.<BR><BR>When you're done, you might do a benchmark between using the temp table versus sql server to see if it ...

TEXT – Text strings, stored using the database encoding (UTF-8 or UTF-16). BLOB – Binary data, stored exactly as input. With this in mind, lets create some tables.