If you want to see a difference in how you look then in about 6 months to 1 year of good training and eating it will become noticeable. To pack serious muscle and be "big" I would say about 2 or 3 years.
For top results i.e. professional level (either bodybuiling or powerlifting)... many years.
Stick to it though, the sport has many small rewards along the way, and as you improve you can set higher and higher goals.
Edit: Now, I really am curious. What do you and the person below think you can achieve in weightlifting in 6-8 weeks? I really want to hear this... [ Alin75's advice column | Ask Alin75 A Question ]
Attention: NOTHING on this site may be reproduced in any fashion whatsoever without explicit consent (in writing) of the owner of said material, unless otherwise stated on the page where the content originated. Search engines are free to index and cache our content. Users who post their account names or personal information in their questions have no expectation of privacy beyond that point for anything they disclose. Questions are otherwise considered anonymous to the general public.