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.