How do i link same named records from Access in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thonydi - 28 Jul 2006 10:45 GMT

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)

Reply to this Message

Ripthorn - 28 Jul 2006 12:03 GMT

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)

Reply to this Message

John Vinson - 29 Jul 2006 06:02 GMT

>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)

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]

Reply to this Message