Access Insert statement

[salwa]

Appreciate anyone explaining to me what this statement does, in particular the IN 'K:.... part



INSERT INTO VLOvertimeWorked ( COSTCENTRE, GEOGRAPHY, LABOURCODE, EMP_ID, NAME, Hours, Days, PeriodFrom, PeriodTo ) IN 'K:\Payroll\PayrollProcesses\ExportedReports\83\HR Data\HRAbsenteeismTemp.mdb'

thanks heaps

[June7]

The IN 'K...' is specifying file with table to receive data. What you show is only half of an INSERT action.

This is used to save data out to another Access file, not the db code is located in.

[Minty]

You need to use the correct syntax - a basic guide here:
https://www.w3schools.com/sql/sql_insert.asp