I am working with MS Access 2010 and SQL Server 2008 R2.
Currently, I use .ADPs and VBA to append data into the SQL Database table(s). I understand that in Office 2013, "ADPs are Dead!". I am looking for best practice Access VBA examples that append data from an Access table into a SQL Table. Currently, with VBA, I can link the SQL table and use vba to append the data, but that method runs very slow; I'm looking for a faster programmatic process, perhaps using a Pass-Through query.
Any help will be appreciated. Thanks in Advance
Currently, I use .ADPs and VBA to append data into the SQL Database table(s). I understand that in Office 2013, "ADPs are Dead!". I am looking for best practice Access VBA examples that append data from an Access table into a SQL Table. Currently, with VBA, I can link the SQL table and use vba to append the data, but that method runs very slow; I'm looking for a faster programmatic process, perhaps using a Pass-Through query.
Any help will be appreciated. Thanks in Advance