Saving data from MsAccess to Sql table
Posted on 2013-05-14
My client has an access app that generates and sends emails and then saves the emails to a folder on their network. Now I need to include logic to save these locations to a SQL table. I have done the below but nothing inserts into my SQL table and there aren't any errors:
dim db as database
dim strconnect as string
dim strsql as string
strsql="insert into [myserver].[tablename] (column1,column2) values (value1, value2);"
db.execute strsql, dbfailonerror
Why won't my record insert?