JAYRAM

JAYRAM

  • NA
  • 272
  • 208.4k

how to convert pdf data values to sql database

Nov 19 2013 3:33 AM
i have data like pdf format like below format....


how to convert below data to sql table ......
like below format ,,
sno,Elector's Name,Husband's Name:,House No:,voterid,pno


........................................................
i attached pdf file also ....

 2 
Age: Sex: Female
ZTS0104497
Elector's Name:
Husband's Name:
House No:
G Lalita Devi 
G Gopal Areddy 
1-1-601/1
 63 
 3 
Age: Sex: Male
ZTS0224949
Elector's Name:
Father's Name:
House No:
Gopal Areddy 
Deva Areddy 
1-1-601/1
 70 
 4 
Age: Sex: Female
ZTS1504588
Elector's Name:
Father's Name:
House No:
NAGAMALLISHWARI 
KOTI REDDY 
1-1-602/1
 22 
 5 
Age: Sex: Male
ZTS0287003
Elector's Name:
Father's Name:
House No:
Marupaka Santos Kumar 
Manohaar 
1-1-602/1
 28 
 6 
Age: Sex: Male
ZTS0287011
Elector's Name:
Father's Name:
House No:
Marupaka Manohaar 
Lakshmaiah 
1-1-602/1
 58 
 7 
Age: Sex: Male
ZTS2381945
Elector's Name:
Father's Name:
House No:
BHANU MURTHY 
NAWADA
LAXIMINARAYAN 
NAWADA
1-1-602/1 PLOT NO.92 S
 42 
 8 
Age: Sex: Female
ZTS2382653
Elector's Name:
Husband's Name:
House No:
PRIYA NAWADA
BHANU MURTHY 
NAWADA
1-1-602/1 PLOT NO.92 S
 31 
 9 
Age: Sex: Female
ZTS2382752
Elector's Name:
Husband's Name:
House No:
DURGA BHAVANI 
MARUPAKA
SANTOSH 
MARUPAKA
1-1-602/1 PLOT NO.92 S
 25 
 10 
Age: Sex: Male
ZTS2383065
Elector's Name:
Father's Name:
House No:
LAXMIKANTH 
MARUPAKA
MANOHAR 
MARUPAKA
1-1-602/1 PLOT NO.92 S
 24 
 11 
Age: Sex: Male
ZTS0647073
Elector's Name:
Father's Name:
House No:
Goel Gopal 
Ramanathan 
1-1-602/2
 38 
 12 
Age: Sex: Male
ZTS0916015
Elector's Name:
Father's Name:
House No:
RAJENDER KUMAR 
KAMMAKOLU
LAXMINARAYANA 
KAMMAKOLU
1-1-602/2
 48 
 13 
Age: Sex: Female
ZTS0619619
Elector's Name:
Husband's Name:
House No:
Usha Goel 
Gopal Goel 
1-1-602/2
 33 
 14 
Age: Sex: Female
ZTS2550482
Elector's Name:
Husband's Name:
House No:
SUVARNA KATA
MANOHAR KATA
1-1-602/2
 54 
 15 
Age: Sex: Female
ZTS2550516
Elector's Name:
Father's Name:
House No:
SADHANA KATA
MANOHAR KATA

Attachment: partno1.rar

Answers (2)