I am using the following code within an Access database to retrieve data from Oracle and build a local table within the Access database.

DoCmd.RunSQL "Select Field1, Field2, " _
& "'' as StartDate, '' as Spare, '' as StartSalary" _
& " into tbl_TEST from [ADMIN.EMPLOYEE_ INFO] " _
& "IN 'ODBC Database;' 'ODBC;DSN=ITSP; UID=Userid;PWD= pswrd;'"

This...