Sam92Legacy
Technical User
I have a daily task that requires me to append a number of rows from a spreadsheet into an Access table. I linked the worksheet path and created an append query for it.
One of the fields in the spreadsheet routinely includes more than 255 characters, but Access still links it as a text field. The field I want to append to is a memo, but any record from the spreadsheet where the field is an excess of 255 caharacters will fail to append correctly; all fields for that record are appended but the memo field is set to null.
Is there any way to force Access to link that field as a memo rather than text field? I could just import the spreadsheet rather than link it, but that adds a bunch of steps I'd rather not deal with.
Thanks,
Sam Martin
One of the fields in the spreadsheet routinely includes more than 255 characters, but Access still links it as a text field. The field I want to append to is a memo, but any record from the spreadsheet where the field is an excess of 255 caharacters will fail to append correctly; all fields for that record are appended but the memo field is set to null.
Is there any way to force Access to link that field as a memo rather than text field? I could just import the spreadsheet rather than link it, but that adds a bunch of steps I'd rather not deal with.
Thanks,
Sam Martin