@SamT -- NOTHING is ever that easy
Well, #*(%^)#&%#@)##%^*(#*!!! I forgot the structure of that 47Mb file


From the OP to now, I've been able to do the majority of the work myself. So, I've already sorted the bcp files, the csv files and the filters for class ref 110. I've actually done mostly everything mentioned in the OP.

I've imported the final data (that's already been cleaned up and filtered) into the 47mb spreadsheet I just sent. The only thing I need to do now is merge the sheets (in the 47mb file) into one table.
First I did not download the cloud file in your last post. Not going to if it's another 47M.


The extract_class field/file has the 'regno number' (the primary key) as well as a 'class ref'. I'm only interested in 'regno numbers' with a 'class ref' of 110.
I am a bit confused. You want all Regnos that have at least one instance with a Class 110

The Collected Data Book (47Mb) is only those Regnos?



You want One Table with all Data from all Sheets? Can't be done with the data structures you have provided.

If you look at my Table Headers attachment, you will see that there is no common Secondary Key that would enable consolidating records. It may be different in either the csv files or the bcp files. I dunno, you won't discuss them with us.

So. I've been looking at everything to see what we can do. I know that (with several consolidation) we can provide a table that has most things on it, But... Listing Trustees and Volunteers (By Regno & Charity name) requires another Table. The financials - Part B,also require another table .Charity Objectives would be on final Table.

These are the tables I think ATT we can iteratively consolidate into one. There is a linkage of Columns that can be used as Secondary Keys:
extract_name as table_name
extract_acct_submit
extract_ar_submit
extract_charity_aoo
extract_registration
extract_financial
extract_main_charity
Please don't ask us to do more free work than we have to.
Please let us decide the easiest way to accomplish what you need.
To paraphrase a great programmer (IIRC, Spolski) Sometimes it is better to just start over. At least you learned something the fist time.