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 ...

Here's a SQL statement that uses the values in the temporary table to retrieve rows from one table and insert them into another table: Insert Into Employees (FirstName, LastName, Status) Select ...