Transfer from Access to Excel

[@ndy]

Hey fella's,

I have a table with an Id and LineId in Access. I have these Id's also
in
an Excel sheet. Is it possible to find the Id's in the Excel sheet
corresponding from Acces and then adapt the values which belong to the
Id's.

Thanks in advance.

Exmpl:

Access Excel
******* ******
ID LineID AM ID LineID AM
--- ------ --- --- ------- ---
150 1501 200 150 1501 100 (change to 200!!)
150 1502 450 150 1502 100 (change to 450!!)
150 1503 640 150 1503 300 (change to 640!!)
151 1511 700 151 1511 400 (change to 700!!)
152 1521 720 152 1521 600 (change to 720!!)
152 1522 900 152 1522 400 (change to 900!!)

[Bilk Whitey]

an*******@hotmail.com (@ndy) wrote:

Hey fella's,

I have a table with an Id and LineId in Access. I have these Id's also
in
an Excel sheet. Is it possible to find the Id's in the Excel sheet
corresponding from Acces and then adapt the values which belong to the
Id's.

Thanks in advance.

Exmpl:

Access Excel
******* ******
ID LineID AM ID LineID AM
--- ------ --- --- ------- ---
150 1501 200 150 1501 100 (change to 200!!)
150 1502 450 150 1502 100 (change to 450!!)
150 1503 640 150 1503 300 (change to 640!!)
151 1511 700 151 1511 400 (change to 700!!)
152 1521 720 152 1521 600 (change to 720!!)
152 1522 900 152 1522 400 (change to 900!!)

Hi Andy.

Link to your Excel spreadsheet from your Access database, then include both
recordsets in a query and join them using the PKs (I'm assuming that's
'LineID'). Include both 'AM' fields in the query grid - this query will
then return records which are common to both recordsets.

Change to an 'update' query type and include the appropriate (source)
table/field name* in the 'Update to' box for the field you want to update.
Run the query.

I highly recommend that you back up your files first.

*Note that the source field should be referred to as [tblTable].[Field]
since, in the example you give, they both have the same field name.

HTH - Keith.
www.keithwilby.com