views:

10

answers:

0

I am importing data (Pdf, Xls, Doc, Txt) into an Access 2007 Database....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 in Access 2007????

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