How do i link same named records from Access in Excel

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

Guest

I have an acces database and would like to update it with records that are in
excel.These fields are names.eg.Continent,Country and Town.The updated record
sets are in the excel file(e.g.Geocoodinates)
 
i don't know if this is what your after but we just save our excel
spreadsheet as a csv file and then use the standard import in access to
bring the data into access, each coloum in excel is headed the same as
the field names in the table.
 
I have an acces database and would like to update it with records that are in
excel.These fields are names.eg.Continent,Country and Town.The updated record
sets are in the excel file(e.g.Geocoodinates)
Click to expand...

You can use File... Get External Data... Import, or File... Get
External Data... Link to link to an Excel file. You can then create an
Update query joining the imported (or possibly, linked) Excel data to
your local table by the appropriate field (I have no idea what that
field might be), and change the query into an Update query; you should
then be able to update whatever it is you want updated (you didn't
say).

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Mail merge 2
how do i update records 12
Access Automatically Send a notification email once a record is added 0
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Copying data from excel to access 3
Access newbie needs steer 2
how do I automatically update a table with excel inforamtion 3

Back
Top