Import from multiple docs to one record in a table (1 Viewer)

Hi there,

It's my first time trying to work with big imports.

What I wanted to do was try and import from 5 excel sheets into one table and merge them into 1 record.
E.g. I have pupils with test results for maths, English and ICT.
I have 3 spreadsheets called Maths, English and ICT and I wanted to merge them into the test results table all under that specific pupil.

Also I've been searching how to create an import button on my form as I have locked all the ribbons but can't find a simple way, and especially if I want the user to specify the file path.

Thanks very much

I assume that you want to end up with a table structure like this:

Name
Maths
English
ICT

with one record looking like this for example:

Name Maths English ICT
Fred Bloggs 78 56 87

I suggest that you aim for a table like this
Name
Subject
Mark

so you get up to three records per student as follows:

Name Subject Mark
Fred Bloggs Maths 78
Fred Bloggs English 56
Fred Bloggs ICT 87

This will be easier to work with and probably easier to set up. You can then create a query later which presents the data all in one record for each student.

Whilst you should not really be repeating the name it may be ok for such
a limited application.

Be aware that a particular students name may be spelt differently in one of the spreadsheets.

Thanks, but if I want to print a report afterwards for every student will a cross tab query work?

Yes. Normalizing the data will make it easier to add and change. Then you would use cross-tabs or subreports to produce outputs for humans.