By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,292 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,292 IT Pros & Developers. It's quick & easy.

Transfer from Access to Excel

P: n/a
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!!)
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.