Merging Excel Data

glavian

Keith
Local time
Today, 15:28
Joined
Dec 18, 2008
Messages
2
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
 
You can access an Excle spreadsheet as a linked table. See Access help for more info
 
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom