> That's no problem, but then how to I actually get the data in
> [TaxWitholding]
> and [NetPay] into tblInvoices? Is this an update query?
>
> Thanks again,
> spence
>
> "Douglas J. Steele" wrote:
>
>> Try linking to the Excel spreadsheet. You can then join the two tables,
>> even
>> though one's in Excel.
>>
>> If that doesn't work, try importing to a temporary table.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>>
http://I.Am/DougSteele>> (no private e-mails, please)
>>
>>
>> "spence" <spence[ at ]discussions.microsoft.com> wrote in message
>> news:EA0BA8F3-EB52-4BA4-851A-8DAE516AA6F7[ at ]microsoft.com...
>> >I have a simple table tblInvoices with the following fields:
>> >
>> > [InvoiceID] (key field)
>> > [EmployeeID]
>> > [Payrate]
>> > [Hours]
>> > [TaxWithholding]
>> > [NetPay]
>> >
>> > My staff enters the EmployeeID, Payrate, and Hours via a form and then
>> > I
>> > export a report with these fields plus InvoiceID to Excel. I send the
>> > spreadsheet to our payroll company. They return us the same Excel
>> > spreadsheet
>> > with the addition of fields for TaxWithholding and NetPay. I want to be
>> > able
>> > to import TaxWithholding and NetPay into the corresponding Access
>> > records
>> > using key field [InvID]. I thought this would be simple but haven't
>> > been
>> > able
>> > to figure out how to pull in particular fields in a given record.
>> > Possible?
>> >
>> > thanks,
>> > spence
>>
>>
>>