Last post Dec 28, 2014 09:28 PM by Lorris
Dec 22, 2014 01:44 PM|Shruthin|LINK
I am using vs2010 and sql server 2008 . Using Asp.net web application(c#) i need to upload pdf file. That Pdf file contains some data. that data should be stored in Sql Database Table .
Can anyone please suggest me how to do this in easiest way and is it possible ?
Waiting for most valuable response :)
Dec 23, 2014 12:33 AM|stanly|LINK
Better save PDF file in any folder and save file path SQL database...
If you want to save file content in database, then refer below links...
Dec 23, 2014 07:37 AM|Shruthin|LINK
Thank you stanly . But i need to read the Table inside in PDF file .That data need to store in Sql table :) .For example i have Pdf for store the student attendance details with following columns
Columns: time in, time out, total time, class number, date, first and last name
Data's : 10: am, 9pm, 11 hr, 1, 21/12/20014, shruthi, nagaraj.
My SQL table also contains same columns (time in, time out, total time, class number, date, first and last name).
I need to insert those pdf data's in to sql table :)
I don't want to insert Pdf file.
Dec 28, 2014 09:28 PM|Lorris|LINK
As for this issue, I suppose perhaps you need some tools to achieve it. Here are some similar threads, you could refer to them.
Import PDF file data into SQL table using SSIS
How to extract data from a PDF?
Convert Pdf data to Sql table in asp.net
Import data from PDF to SQL Server
Hope they can help you.