Importing Data From Excel

[mbpaul]

Hey I'm looking for a bit of help importing data from two excel sources to one table. I have a table with: Unit, Info1, info2, info3, info4, info5, info6, info7. I have been able to import from the first file which has all of the unit information-'info1-5'. I need to import another file to fill 'info6-7' based on specific unit numbers. I have created two excel tables the first with the headers "unit, info1-5" and the second with the headers "unit, info6-7." The first works fine and adds all the data I want it to, but when I try to do the same with the second it doesn't add any new data. Is it possible to do what I need? I cannot add the last two fields to my first spread sheet because it would involve sorting through 700+ units and adding the data manually to 400+ of them.

 

[jdraw]

Database is NOT spreadsheet. You need to research relational data base design.
Spend some time reading this
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

You should familiarize yourself with Normalization.

Good luck

 

[Alansidman]

In addition to Jack's reference, look at this link on how to normalize your data once you understand what it is all about.

http://www.datawright.com.au/access_resources/normalizing_tables_with_repeating_fields_using_VBA.htm

 

[Pat Hartman]

You would import the two sheets separately. Modify the design of the primary table to add the additional columns. Then create a query that joins the two tables on the common key and update the empty columns in the main table with the populated columns from the second table.

We can't tell from your description what type of data you are working with but based on your column names - info1-5, it sounds like it is not normalized and you may need to restructure the table to use it effectively in Access.