Post reply

Data migration from pdf to sql server 2000

  • August 26, 2005 at 9:12 am

    #66889

    How do I transfer data from a pdf file to sql server table? i tried a third party s/w for conversion and it converted the pdf to a text file. But in the table(the auto creation of table), I find two of the fields are squeezed together into one field of the table and the second column only shows the null values. i think I need to format the text file by each row, which is too cumbersome

    I have done comma delimited in DTS.

    Any suggestions for any simpler way of migrating data from a pdf table to ss table?

    Thanks

  • August 29, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • August 29, 2005 at 9:05 am

    #585876

    There is no way directly to do this. You need some software that can read the PDF as you used. If things didn't work out, you could search for software, but how often do you need to do this? How much data? Doing it by hand, paying a temp, etc. might be the best way.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • August 29, 2005 at 9:14 am

    #585886

    Thanks Steve! Very nice of you for taking care of our small problems! Anyway, this is only once in a while that I come across such type of migration. I guess, I have to do the formatting by hand row by row...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply