I have an empty Access table. I need to select data from a SQL DB and insert into the Access table. I eventually will do this using VBA but for now I am just trying to get the major steps working.
The Access table is defined. Named TSHrs. Contains 3 fields (TSEmpID, TSHrs, TSDate)
I am doing a Pass-Through query
The ODBC connection is defined.
The query is:
Insert into TSHrs ([TSEmpID], [TSHrs], [TSDate])
Select EmployeeID as [EmpID]
) as [Hours]
) AS [RptMonth]
group by EmployeeID, DatePart(Year,DateWorked)*
order by EmployeeID
When I run the query in Access I get the pictured error. It appears I am trying to reference TSHrs in the SQL DB the ODBC references. Have I approached this wrong?