Just an approximate amount. We moved our dining table into the sunroom and would like to install a new light fixture in the center of the ceiling and would like to know how much and what the project would entail. Thanks!
no access from the attic =(
yeah i am guessing it will be 0+ since they will have to take some of the drywall and ceiling out and replace it.

Do you have access to the ceiling from above, such as an attic? If so, piece of cake. Figure 1-1/2 hours labor plus materials. I’d guess $100-125, depending on where you live. If there is no access, you are looking at a lot more. Have a local electrician give you an estimate, as there is no way to tell what obstacles there will be from here. Hope this helps.
I believe it cost us about 30-50 dollars but we had a friend do it so I don’t really know beyond that.
It will be about $30 for the wire, $20 for the fixture and $50 an hour for the electrician.
Sassy,
You could skip the new drywall and paint and ceiling patching and be creative by putting a new beam across the top of the room (or a couple in a x-pattern), by using a pipe, or doing something of that nature. For the record, I doubt that they can match a splice perfectly unless they completely repaint and resurface the entire ceiling. Use your imagination and also, go to a specialty store. I’m sure many people run into similar problems. I had the inaccessibility issue when I had to run component video cable to my projector on the other side of a room w/ a vaulted ceiling. No can do. (I ended up following the baseboard around the room).
You could use 2 or 3 strategically placed and powerful wall lights (I say 2 or 3 to avoid shadows and strange lighting effects).
Also, it might be weird, but I did basically the same thing shown below. The fixture and all splices were a grand total of 26 bucks.
http://www.boingboing.net/2006/03/28/howto-make-a-fractal.html
I used CFL lights because I could get so much more clean white light for the power available. Just make sure you don’t exceed the wattage rating for the socket taking all the load at the top. (usually 600 watts total). People laugh but it’s quite the ice breaker and conversation starter.
All I know is, I’m so tight, I’d be more likely to use a jar of crushed lightning bug butts before I spent 500 bucks on a light of any kind.
Good luck
-Kevin