importing designated fields from excel using key field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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 said:
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

(no private e-mails, please)


spence said:
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
Click to expand...
Click to expand...
 
Yes, it would be an update query.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


spence said:
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 said:
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

(no private e-mails, please)


spence said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top