Alternative?

Is there a VB function to add information to a table in an access database? I'm using SQL right now, but it is such a pain! I can't add records to the table that contain "&". Like if I'm adding a string to say column "filname" in a table and the filename is "Huey Lewis & The News". Any suggestions appreciated.

Lets see your code, but your SQL string should look something like this:

Code:

---

strSQL = "INSERT INTO table1 (field1) VALUES ('" & text1.text & "')"
objConn.execute strsql

---

This should be enough:

VB Code:

'Store the info as strings
    strFilepath = fname
    strFileName = MusicMaster.File1.List(x)
    strFileSize = FileLen(fname)
    strTitle = RTrim(Songname)
    strArtist = RTrim(Artist)
    
    
    
'Use SQL to insert the information in the strings into the table
SQL = "INSERT into " & table & "(FilePath, Filename, Filesize,
_ Artist, Title) VALUES ('" _
& Replace(strFilepath, "'", "''") & "','" _
& Replace(strFileName, "'", "''") & "','" _
& Replace(strFileSize, "'", "''") & "','" _
& Replace(strArtist, "'", "''") & "','" _
& Replace(strTitle, "'", "''") & "')"
 
 
Cnn.Execute (SQL)
 
Next

Quote:

---

I can't add records to the table that contain "&".

---

I didn't understand this, even from your example. Can you give a more elaborate example.

BTW, it SHOULD work. The code uve posted is fine.