Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 export pdf to sql

Author  Topic 

sebastian11c
Posting Yak Master

129 Posts

Posted - 2012-05-04 : 12:19:53
hi everybody

i have a problem,, ihvae a pdf file with 1300 pages, and i dont know how export this pdf to my sql db.


any idea, any software any help will be appreciate

many many thanks in advanced

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-05-04 : 12:48:16
First question is: why? Do you want to store the PDF file in a SQL Server table? Or is there data in the PDF file that you want to extract and import into SQL Server?
Go to Top of Page

sebastian11c
Posting Yak Master

129 Posts

Posted - 2012-05-04 : 12:58:52
hi

is there data in the PDF file that i want to extract and import into SQL Server
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-05-04 : 13:23:16
You'll need to use a program that converts PDF files to text or other formats. Google is your friend. Be warned (this is based on my past experience) they will extract text fine, but they WILL NOT retain any useful formatting. If you have tabular data in the PDF it will get all mashed together and you'll have difficulty identifying columns.
Go to Top of Page

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-05-04 : 14:03:24
is this a one time thing or a continuous process?
is the data delimited or just text you want to import?

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -