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.
    
        
            
                
                    
                        
                            
                                | Author | 
                                
                                 Topic  | 
                             
                            
                                    | 
                                         sebastian11c 
                                        Posting Yak  Master 
                                         
                                        
                                        129 Posts  | 
                                        
                                        
                                            
                                            
                                             Posted - 2012-05-04 : 12:19:53
                                            
  | 
                                             
                                            
                                            | hi everybodyi 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 appreciatemany 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?  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     sebastian11c 
                                    Posting Yak  Master 
                                     
                                    
                                    129 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2012-05-04 : 12:58:52
                                          
  | 
                                         
                                        
                                          | hiis there data in the PDF file that i want to extract and import into SQL Server  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     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.  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     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  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |