February 3, 2004 at 4:24 am
Hai,
Is it possible to take texts from a PDF file to SQL server ?
(either by TSQL or by any programing languages)
thanks
February 3, 2004 at 4:27 am
Do you want to store the whole file or just the text?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 3, 2004 at 4:33 am
i want to read the text only
February 3, 2004 at 6:28 am
Now, if you want to read the text, you can only do this when you have stored only the text.
When you have stored the file and want to read the text, I guess that won't work as you need to retrieve the file to read the text.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 3, 2004 at 6:43 am
What I do
1. Use Acrobat (min v5) to save the PDF in RTF format
2. Use Word op open RTF file
3. Copy text and store in database
I do 1 manually and use an app to do 2 & 3.
Be warned the process is not 100% accurate, you do not get all the formatting but you should get the text
Far away is close at hand in the images of elsewhere.
Anon.
February 3, 2004 at 7:57 am
OK, thankls
Actually my aim is to provide a search facility for our Web Server.
Microsoft Index Server and ASP Search is not meeting our requirement. so i thought of taking all the file content to database so that i can do anything.
Any suggestion Frank , David
Thanks & Regards Gvd
February 3, 2004 at 8:07 am
![]() | Actually my aim is to provide a search facility for our Web Server. |
That is why I do it. I use Full Text search to seach column in db and use ref in row to point to PDF that is external to db.
Far away is close at hand in the images of elsewhere.
Anon.
February 3, 2004 at 8:38 am
ok thanks
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply