XLSM in Access

[xsbucks]

Hey you guys, Can someone let me know if this is possible and as gently as you can explain how to do it?

I have an access DB
I have an XLSM Data Sheet
In the XLSM I have A few Rows with Fields.
In the Fields I have a few matching fields as in the Access DB
I also have a few extra fields that i want to add to the Access DB
Question is,
1) Is it possible. ( I believe it is because you guys are amazing at this. )
2)I want the new fields of the ADB to Populate from the XMLS in the proper rows based on the ID number in the ADB.

I am sorry but this is the best way i can explain it. Thanks for your help.

[June7]

Adding fields is easy. Open table in design view and add fields.

If the worksheet is simple structure of header row and data rows (no sub heading rows or other complications), set up a link to the spreadsheet or import. Then can work with the linked spreadsheet like a table. Build UPDATE query.

If link or import is not practical, will need VBA code to accomplish.

[xsbucks]

Okay i was able to setup the relationship, I set it up as a relationship by ID #'s what would i need to do now to run an update query to have the fields populate in the appropriate Row? If i run an update query what would be the query script i would run? Thanks!

[June7]

Access Help has guidelines on using the query designer to build queries, including the UPDATE structure.

[xsbucks]

That didn't help at all. I have accessed the help file and couldn't track down what i needed. Thanks for trying hopefully someone can give me a little more exact help than that.

[June7]

Review:
http://office.microsoft.com/en-us/ac...010076527.aspx