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!

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

How to send list box items to database

Status
Not open for further replies.

aos

MIS
Feb 28, 2002
20
US
Hi!
Just wondering how to send items in a listbox to database. My listbox is holding several dates and i want to send those dates to a table in access.
 
Hi,

Loop through the listbox items and add them to data base.
Something like

for i = list1.listcount-1
conn.execute "INSERT INTO TblMYTable(MyDate) VALUES (#" & list1.list(i) & "#)"
next i
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top