I've been getting sharp pains in my chest and lightheaded accompanied by pain on left side of head this has been coming and going for 2 weeks.

Need for examination: It is not feasible to provide a meaningful opinion without examining you and your symptoms warrant immediate evaluation by a physician. If you have fever it would be prudent for you to see your doctor as soon as possible or go to an emergency room.

Be seen: While this not sound classic for something like heart pain, that is always a concern in someone with chest pain, even a woman in her early 40s. The lightheadedness and the presence for 2 weeks, suggests a need to have things checked out.