I am using SQL server 2012, Access 2010.
I need to transfer data from the SQL database table named: vntgCust
to a Access table named: tblCust
All the fields in the SQL table should copy into the access table.
What statement can I use to accomplish this?
Note: I don't want to setup ODBC connection names to the SQL database on each computer running this.