pdf to sql server

[scotspine]

i have data stuck in a pdf file in the format

[country] [abbrv]

for example

Djibouti DJ 262

i need to get this into sql server in the obvious 3 columns. any ideas anyone?


's ok ta. got it...

 

[hyperD]

Adobe Acrobat component /TallComponent object model to read doc then squirt out using ADO.NET?

 

[DimPrawn]

Stick the PDF up online on a website.

goto http://www.adobe.com/products/acrobat/access_onlinetools.html

Convert the PDF to html or plain text.

Parse the html/txt into BCP format.

BCP into SQL Server.

 

[scotspine]

that's a good facility - didn't know it existed. effectively that is what i did by a roundabout route.

 

[Joe Black]

Regex is also another option if you're skilled in that black art.

 

[scotspine]

Regex is also another option if you're skilled in that black art.

grrrrrrr.....

 

[TheMonkey]

grrrrrrr.....

I'll do regexes to your heart's content for £75/hr!