path

  • Thread starter Thread starter REY
  • Start date Start date
R

REY

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

In the
Append To:(field
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!!!!
 
I am writing a query that will append records
from "employee.mdb , currtimesheet(table) to
employeebudget.mdb , timesheets(table).

In the
Append To:(field
What format is used for database path and table.
Click to expand...
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
 
Back
Top