How would you store this?

[techneophyte]

I am going out and importing data (Pdfs, Xls, Doc, Txt)....then I convert it to Base64 (called strData below). If the original was about 150K or less then I can save the converted file (about 250K characters) into a memo field. However, if the original is larger than that then the code gives me "run-time error '2498': An expression you entered is the wrong data type for one of the arguments".

Any suggestions how to save the larger files????

sSQL = "Insert Into tblAttachment(AttachmentDetail) Select '" & strData & "';"
DoCmd.RunSQL sSQL

[NoellaG]

Use a memo field