import excel into form with combobox fields

[MyWebdots]

Hi there. A very newbie question follows - my apologies for ignorance.

We built a database (MS Access 2007) with several tables. The master table was built correctly with FKs from the other tables in order to have auto populating fields in a form. (combo boxes were used). It worked well.

We 'exported' data from the FORM. This exported data into a single excel spreadsheet with columns which included fields from several of the access tables. (because of the combo boxes).

We made changes to the single excel spreadsheet (but no new or changed names of columns/fields - only typing errors of data).

Then we import BACK into the DB - but it wants to import into a TABLE not a FORM. There is not a single TABLE that has all the values because the FORM was made up of several TABLES.

So how do we get the exported data, imported back in? Should this be easy? I am really confused - Would appreciate someone's assistance.

Best regards


Katie

[dsmacs]

You will need to import into a temporary table and as long as you can create a relationship between the import table and the the tables that need to be updated, use a append query to update.

[MyWebdots]

Thank you - I will try that !