Merging Excel Data

[glavian]

Access 2007:

Is there any way to merge excel data into a table based on a primary key?

If not is there a way I could import the excel data into it's own table and then merge the table into another table based on primary key.

Keith

 

[Rabbie]

You can access an Excle spreadsheet as a linked table. See Access help for more info

 

[neileg]

As Rabbie says you can link an Excel sheet as a table. You can also import it into Access as a table. Either way, you would then use queries to link this data with your existing data. Perhaps adding the data to a table is the best approach or simply using the query as a data source may be best. Depends on the data and how dynamic it is.

 

[Mhypertext]

Yeah inmport it all into access

Then link it all in the relationships tab then click on design Query

and put the files u imported into the design window and click away on what you want to show then hit run and boom your done click the x save it then over on the left right click and export it