how do I store a text file in MS ACCESS?

[qb828]

I know that Oracle let you store large files?

Could I do same thing with MS ACESS?

I just want to store text files into MS ACCESS.(or link them by using the file name)

I want to query the database and look for the matching files and get the file name (or open up the file and see the content of the file)

Could someone hint me how to do this Or suggest another way to do this?



QB

 

[KenReay]

Hi

In Access, there is a Memo datatype (in tables), this will allow you to store upto 64kb. You can search memo fields using Instr(), you can also use other string functions on them. In SQL you can use LIKE etc but you cannot ORDER BY a memo field.

Alternatively you could as you say just store the path to the text file and open it up using the filesystem object or good old fashioned OPEN, INPUT etc

Hope this helps

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK