Pdf To database

[kirantechno]

I have a pdf file
it has 12k ppl data
i need to insert that data into any database (oracle, access, mysql), using VB6.0

here is the pdf file : http://ceoandhra.nic.in/ERolls/PDF/E...8/A2180001.pdf

i have been working it... but i could not get the path to do that...

hope u guys will help me out to.

thanks in advance

[kadghar]

I have a pdf file
it has 12k ppl data
i need to insert that data into any database (oracle, access, mysql), using VB6.0

here is the pdf file : http://ceoandhra.nic.in/ERolls/PDF/E...8/A2180001.pdf

i have been working it... but i could not get the path to do that...

hope u guys will help me out to.

thanks in advance

Im not sure, but i think you cant export information from a pdf with the acrobat reader, you need the acroba editor (or whatever its name is). With that software you're even able to export the data to Excel.

Anyway, if you find another way, please share it here, because i've had that very same trouble.

Kad

[kirantechno]

Hi kad,
thanks for response,
for that I have converted the pdf to txt, (I used the tool pdf to txt from http://www.pdf-to-html-word.com, its free)
It gives the n no. of txt files depending up on the n no. pages in .pdf file.

With the help of vba.strings.replace, vba.string.split functions I made a conforble format for easy data retrieval. Then I placed in a Access .

Feel free to mail me for more info.
E-mail address removed by Moderator
------> If you know any .ocx which help to convert the pdf to txt let me know that will be great help for me

[Killer42]

Sorry kirantechno, if people want to contact you off-list they'll have to do so by Private Message, or through the send an e-mail" button in your profile. Site guidelines prohibit the posting of e-mail address, your own or anyone else's. This is to prevent them being harvested by scammers and spammers.

[kadghar]

Hi kad,
thanks for response,
for that I have converted the pdf to txt, (I used the tool pdf to txt from http://www.pdf-to-html-word.com, its free)
It gives the n no. of txt files depending up on the n no. pages in .pdf file.

Well that sounds great, thanks.
I'll check it out.