1
Answer

Search by text long binary document

Marvin kakuru

Marvin kakuru

11y
808
1
Hi everyone

Iam trying to develop a knowledge bank and I have saved pdf's , word/excel documents in my database as long binary in a column in my access database. Now I would like to select documents from my database that contain a word for example "amortization" in their text by typing this word in my textbox1.text.
Can any one help, I will be very grateful.
Thanks in advance
Best Regards
Answers (1)
0
Suthish Nair

Suthish Nair

NA 38.4k 4.6m 13y
another duplicate
0
John Penn

John Penn

NA 4.2k 134.4k 13y
Yes.  You can create a select query that specifies the columns you want:

SELECT FirstName, LastName FROM Person

If "Person" has an identity column, you won't see it in the resultset.