GilaMonster:
EXACT STATEMENT
use mc_poc
go
ALTER TABLE [dbo].[stg_Lineofbusiness_applicationset]
ADD FOREIGN KEY ([mc_lineofbusinessid]) REFERENCES [dbo].[stg_LineofBusiness]([mc_lineofbusinessid])

ERROR
Msg 547, Level 16, State 0, Line 3
The...

on sql server 2016 I have a bridge table with 3 columns:
applicationID
lineofbusinessID

bridge table exists between tables: 
tblApplication (primarykey: applicationID) 
tblLineOfBusiness (primary key: lineofbusinessID)

I want two FKs in bridge table referencing Applications and...

thanks for getting me localhost operational Sue and Michael.

Jason and Steve, you've both understood and helped me.... for no reason but goodness. thank goodness! Many thanks 

The underlying table (in real life!) will sometimes show the duplicate fieldnames for a single
So my sample data shows Area duplicated within Compliance Details and in final results...

I made mistake and corrected:
CommonAttributes column for shared attributes, and they are 3 and 1.
4 and 1 are the grand total of attributes for ReportB reports

I have follow up question, but I will post as new topic.

Great many thanks to both of you.

thanks twin.devil it is also interesting what you show. I plan to use it.

ScottPletcher you made the solution but really curious: Since ReportName is text, how do I read

Does this problem appear solveable with sql query?

Yes, here it is. 

ReportTable

create table ReportTable (
ReportName varchar (20),
AttributeName varchar(30)
);

insert into ReportTable
Values
('Compliance Details', 'Vendor Name'),
('Compliance Details', 'Area'),
('Compliance Details',...

You saved my day.

Installation of Microsoft Access Database Engine 2010 Redistributable completed. Went back to trying to import excel file:

IMPORT WORKED!

Now, I found the below the best configuration for importing

1. select...

No. I used Microsoft Access 2013 Runtime

I'll try the Microsoft Access Database Engine 2010 Redistributable you shared.