G
Guest
Anyone,
I have a user form in Excel where the user can type a description in a
textbox. I wrote SQL INSERT query in VBA to write the description to a
closed workbook that acts as a database file. I’m using the ADO reference
2.7. When the text exceeds 255 characters I receive an error. I know an
Excel cell can hold more than 32k characters, how can I get the text from the
SQL statement to write to the cell in the closed workbook? Another issue I’m
having is the SQL errors when a single quote is typed, is there a simple fix
for this?
I look forward to some help.
I have a user form in Excel where the user can type a description in a
textbox. I wrote SQL INSERT query in VBA to write the description to a
closed workbook that acts as a database file. I’m using the ADO reference
2.7. When the text exceeds 255 characters I receive an error. I know an
Excel cell can hold more than 32k characters, how can I get the text from the
SQL statement to write to the cell in the closed workbook? Another issue I’m
having is the SQL errors when a single quote is typed, is there a simple fix
for this?
I look forward to some help.