Gray5452
asked on
loading related tables from a .xls
How would you load related tables from one excel spreadsheet..
Basically this from one .xls
Market phone
Atlanta 555-435-6789
Atlanta 555-789-3456
Orlando 444-678-5677
Orlando 456-678-5432
Miami 333-678-9876
Needs to go into two tables obviously linked
Market Table
1 Atlanta
2 Orlando
3 Miami
Phone table
1 555-435-6789
1 555-789-3456
2 444-678-5677
2 456-678-5432
3 333-678-9876
Trying to use two data flows and a lookup I can’t figure out how to load the cities only once coming from a spreadsheet.. If I could do that, I could just use a lookup to load the marketed in the phone table..
Any ideas?
Basically this from one .xls
Market phone
Atlanta 555-435-6789
Atlanta 555-789-3456
Orlando 444-678-5677
Orlando 456-678-5432
Miami 333-678-9876
Needs to go into two tables obviously linked
Market Table
1 Atlanta
2 Orlando
3 Miami
Phone table
1 555-435-6789
1 555-789-3456
2 444-678-5677
2 456-678-5432
3 333-678-9876
Trying to use two data flows and a lookup I can’t figure out how to load the cities only once coming from a spreadsheet.. If I could do that, I could just use a lookup to load the marketed in the phone table..
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When i am trying to execute the distributed queries i am getting the following error.
"Msg 7403, Level 16, State 1, Line 2
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered."
Please let me know how to fix it.