That is awesome stuff!

Thanks a ton!

I think that gets me closer but now when I use this command:

INSERT INTO OPENROWSET(

'Microsoft.Jet.OLEDB.4.0','Data Source="D:\Database\00000001.mdb";

User ID=Admin;Password=','SELECT * FROM EMPLOYEE' )

SELECT * FROM [20040817].dbo.Employee

I get the following...