Import PDF data to SQL Sever database

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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?
 

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.
 

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.
 

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.
 

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.
 

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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Members online

Top