1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Import PDF data to SQL Sever database

Discussion in 'Business Applications' started by HedeNelson, Mar 31, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. HedeNelson

    HedeNelson Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    I have much digital data in my computer, I want to import them to database. I want to convert PDF to Excel and then import it to database. so which converter can preserve the original data well?
     
  2. DoubleHelix

    DoubleHelix Banned

    Joined:
    Dec 9, 2004
    Messages:
    24,388
    That's a very complicated request worded ridiculously simply.

    There's a whole truckload of information someone would need to help you. Just extracting data from a PDF into Excel could take quite an effort. Then taking Excel data and getting into a normalized SQL Server database is another herculean task.
     
  3. HedeNelson

    HedeNelson Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    It is really a complicated work. The point is that how to change PDF data to Excel, as I know how to import data to SQL database. I hate tedious copy and paste. Go forward try to resolve this problem.
     
  4. DoubleHelix

    DoubleHelix Banned

    Joined:
    Dec 9, 2004
    Messages:
    24,388
    Excel is usually used to calculate numeric values. A PDF is just text. I'm not getting why you need to put it in Excel and then into SQL. What does having it in Excel do for you? Is the PDF data in tabular format?

    There are programs that extract text from PDFs into Word, but I don't see how that translates to an Excel spreadsheet.
     
  5. HedeNelson

    HedeNelson Thread Starter

    Joined:
    Mar 24, 2010
    Messages:
    5
    I don't think PDF data is in tabular fromat. It is just because the data in PDF is like what in Excel spreadsheet. I consider that if I could convert PDF data to Excel spreadsheet, I would make my work more easiler.

    I have ever try PDF to Word Converter but it is helpless. The table could not be preserved as the original files, and it is not easy to copy word data to excel, I can only type it manually. This indirect way may cost me more energy.
     
  6. DoubleHelix

    DoubleHelix Banned

    Joined:
    Dec 9, 2004
    Messages:
    24,388
    An Excel spreadsheet is in tabular format. Perhaps you're just not familiar with that word.

    Regardless, I don't know of any way to convert a PDF with a table to Excel.
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/913748

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice