I'm presuming following the last post that it's not the right kind of solution, but would this work as an embedded SQL query in Excel? When I've mapped this to...

This should create the test data needed.....

-- Drop tables if they exist

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[Employee]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[Employee]

IF...

Thanks for the feedback so far. Okay, so what I'm actually needing to do is.......

I have two tables, the first is just the employees, the second is a transactional table...