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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple table insertion question

Status
Not open for further replies.
Netooi

Netooi

Programmer
May 15, 2002
29
US
I have a string called "MyStr" that has a name in it.
I want to be able to insert that name into a table in my Access database called tblData that has a field called Name.
Could someone hook me up with the VB to do this?
Thanks,
Netooi
 
Sort by date Sort by votes
After you have connect to the database, use this:

RS.AddNew
RS.fields("Name").value = MyStr
RS.update



 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Question
scraping table in web page 3
2
Replies
24
Views
2K
strongm
strongm
2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
210
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
get data from iframe and table
Replies
0
Views
87
sal21
sal21
sal21
  • Locked
  • Question
WHY! ie dont show the table of result 1
Replies
8
Views
164
sal21
sal21
sal21
  • Locked
  • Question
DRAG AND DROP question. 1
Replies
5
Views
155
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top