Access 2000 reading Foxpro

[MIKElaw]

I can read, and write, to a Foxpro DBF using A2K via ODBC but Foxpro appears to save all memos as BLOB's (name.BLB)

Anyone any ideas on how to, or where I might look for information on, reading and writing to the BLOB.


Mike

 

[ChipsIT]

Mike

Don't know much about these, but accessing them seems to require serialization or streaming (GetChunk). Do a search on Binary Large Objects at MSDN or Google and you come up with lots of possibilities that hopefully may answer your question.

(BLOB) Binary Large Object : A large block of data stored in a database, such as an image or sound file. A BLOB has no structure which can be interpreted by the database management system but is known only by its size and location.

Cheers
Steve