E eacollie Registered User. Local time Today, 11:04 Joined May 14, 2011 Messages 159 Feb 18, 2014 #1 I'm using an INSERT statement which includes a text field that could have commas. INSERT INTO tblTEMP (Name) VALUES ('" & nRname & "') Is there a way to format for this? Thanks!
I'm using an INSERT statement which includes a text field that could have commas. INSERT INTO tblTEMP (Name) VALUES ('" & nRname & "') Is there a way to format for this? Thanks!
Mile-O Back once again... Local time Today, 19:04 Joined Dec 10, 2002 Messages 11,305 Feb 18, 2014 #2 Not quite sure the relevance of the commas, unless your nRname string contains field names separated by them. Can you give some sample data?
Not quite sure the relevance of the commas, unless your nRname string contains field names separated by them. Can you give some sample data?
E eacollie Registered User. Local time Today, 11:04 Joined May 14, 2011 Messages 159 Feb 18, 2014 #3 Examples: Joe's Bar, Henry's Café, Women's Club...... When these values are picked up into the INSERT statement and run, it causes an error.
Examples: Joe's Bar, Henry's Café, Women's Club...... When these values are picked up into the INSERT statement and run, it causes an error.
E eacollie Registered User. Local time Today, 11:04 Joined May 14, 2011 Messages 159 Feb 18, 2014 #4 Got it. Used the Replace() function.
