I am trying to take a text string that will be used as a query in Access from an Excel cell and paste it into a criteria field in query design view in Access. Some of my queries will be lengthy so in Excel I have a character length formula warning me if I go over the character limit in Access.
I found a source stating that "Number of characters in a cell in the query design grid: 1,024". However, when I paste a query from Excel that contains 1,023 character I receive an error stating that "A string can be up to 2048 characters long".
I guess for now I will just keep trimming my query length until it works and document the number.
If anyone has any ideas they would be greatly appreciated.
Please and thank you.
~ Ky
I found a source stating that "Number of characters in a cell in the query design grid: 1,024". However, when I paste a query from Excel that contains 1,023 character I receive an error stating that "A string can be up to 2048 characters long".
I guess for now I will just keep trimming my query length until it works and document the number.
If anyone has any ideas they would be greatly appreciated.
Please and thank you.
~ Ky
