This seems like it should be possible, but I can't get it to work.

I have one table in an MSSQL Server database. I have an access front end. I linked the table.

I want to use Access front end append query GUI to append data into SQL server table.

I keep failing the connection. Do I need to enter connection string in query properties? If so, how does that look, so I can check with what I have tried?
Thanks, BPH

How are you connecting from MS Access to SQL Server DB? Are you using ODBC data source? Define a data source in ODBC data source administrator and try linking SQL server table to MS access. Let us know what kind of error(s) you are getting?

I am using ODBC data source, file dsn, and then in the append query in Access i type the follwing string in the query properties, DestConnectStr

ODBC;DSN=server1;UID=userid;PWD=password;DATABASE= databasename;
Message when run = "OBDC connection to server1 failed."

It is possible to run an append query via access to SQL database table, correct?

Thanks for help.