Import from excel raw data ongoing automatic

[mrjackg]

Hi,

I am trying to automatically import student data from excel into an access relational database structure to use the data to report progress in an ongoing manner.

I have managed to import an excel sheet with the raw data and I analysed it through the wizard and have produced a clean relational database with the data.

I was wondering, now that I have the access database structure defined, is there a way to now import new data from another excel file (new data with same headers) to the newly created relational database? I was hoping to append to the existing data with only new data from the excel sheet.

To clarify:

I have an excel file with Student names and what units they are enrolled in. I also have fields where results are shown with the date. So the data looks like:

Joe Bloggs Unit1 PP 1-01-2013
Joe Bloggs Unit2 PP 1-01-2013
Joe Bloggs Unit3 PP 1-01-2013

I have attached a picture showing the structure of the relational database that works.

I have researched and found useful info but am finding it difficult to get to a solution.

Any help is much appreciated!

 

[GohDiamond]

Is the data periodic updates to the content of your original excel workbook?

Goh

 

[mrjackg]

Hi Goh,

Thanks for the reply, yes the data will be the same data dump from another system with any recent new data added to it.

Jack