MySQL Forums
Forum List  »  Newbie

SQL + string
Posted by: Marc DEVLIEGER
Date: April 10, 2023 05:36AM

What error am I not seeing:


this works :

StrSQL_00 = "INSERT INTO db_00 (" & Strng1 & ") VALUES (" & rs_MSExcel_01!abonnee & ")"


this does not work :

Strng2 = "rs_MSExcel_01!abonnee"
StrSQL_00 = "INSERT INTO db_00 (" & Strng1 & ") VALUES (" & Strng2 & ")"

Options: ReplyQuote


Subject
Written By
Posted
SQL + string
April 10, 2023 05:36AM
April 17, 2023 07:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.