Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL INSETINTO

Status
Not open for further replies.
thegameoflife

thegameoflife

Programmer
Dec 5, 2001
206
US

If keyword_temp = "1,2,3" how would I get that into the table. Now it only will put 123.



Dim strSQL as String

strSQL = "INSERT INTO Keywords (keyword) VALUES ('" & keyword_temp & "');"
DoCmd.RunSQL strSQL
 
Sort by date Sort by votes
strSQL = "INSERT INTO Keywords (keyword) VALUES ('[" & keyword_temp & "]');"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
ADO UpdateBatch SQL Server Example?
Replies
2
Views
294
Andrzejek
Andrzejek
BJZeak
  • Locked
  • Question
SQL Solution?
Replies
1
Views
126
Darrylles
Darrylles
03Explorer
  • Locked
  • Question
Execute SQL causes IDENTITY issue with one statement but not other
Replies
4
Views
182
03Explorer
03Explorer
Mke85
  • Locked
  • Question
VBA, SQL to select and then delete records 1
Replies
16
Views
843
dhookom
dhookom
03Explorer
  • Locked
  • Question
Nested Loops each based on SQL Server Linked table queries (SLOW and INCONSISTENT for run time) 1
Replies
11
Views
310
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top