path

[REY]

I am writing a query that will append records
from "employee.mdb , currtimesheet(table) to
employeebudget.mdb , timesheets(table).

In the
Append Tofield
What format is used for database path and table.

I have searched the help file.
I have read thru on Access 2000 the complete reference.
I can't seem to find it.

HELP!!!!

 

[Tim Ferguson]

I am writing a query that will append records
from "employee.mdb , currtimesheet(table) to
employeebudget.mdb , timesheets(table).

In the
Append Tofield
What format is used for database path and table.

If you are using the SQL view, it's like this:

INSERT INTO Timesheets
(FieldOne, FieldTwo, FieldThree )
IN 'EmployeeBudget.mdb'
SELECT FieldA, FieldB, FieldC
FROM CurrTimeSheet IN 'Employee.mdb';

If you want to use the grid, open the Query Menu and select Append Query,
and fill in the boxes.

Hope that helps


Tim F