I have a database in SQLite which contain tables with blob fields. I have no experience at all working with blobs, and it wasn't me who wrote the blobs to the database. The problem is that I have to access this blob data, but I don't know how.

I've understood that you can store alot of different information in blobs, like audio, images and text. In my case, I'm 99% certain that it's text or CSV in some way. I've been googeling for a couple of hours and can't really find much documentation or useful stuff.

My question is:
When you access a blob, do you have to know the way it was written in order to read it? How do you read it if you know it's some kind of text? The best thing would be to find a way in a VBA enviroment to read the blobs (working with an excel frontend).

Useful links are greatly appreciated