Adding a variable to a Database

[raghitchen]

Hi this is probally a pretty simple one.

All I need to do is write a series of variables I have obtained via VBA code (behind an access form button) referencing some 3rd party data. I now want to add the data in the variables into an access database that I have created in the same project. What is the syntax to do this?

The table is called Music which contains fields Title, Artist, Type and I have the correct data for each of these fields in memory.

Any advice would be appreciated.

 

[dyarwood]

Can you use a SQL code in VBA

Dim cnn As ADODB.Connection
Set cnn = CurrentProject.Connection

strSQL = "INSERT INTO Music"
strSQL = strSQL & vbCrLf & "VALUES ('" & Title & "','"
strSQL = strSQL & Artist & "','" & Type & "')"

cnn.Execute strSQL

MUSIC, TITLE, and ARTIST are variables known within the VBA
Give that a go and let me know if it works.

dyarwood

 

[raghitchen]

Thanks...that worked a treat!

 

[dyarwood]

No problem. I just had to do a similar thing in my DB just before your post.

dyarwood