What we're talking about today is the actual steps of copying SQL Server data into an Access database, copying some of the data in the SQL Server database into an Access database that has the same main structure, not mentioning OpenRowset, Because the Access file and SQL Server are not on a single machine.
The initial idea is to use two recordsets, one to fetch data from SQL, and one to insert data into Access
Because there are more fields in the table, we have to use a loop
while (!m_precordset_sql->adoeof)
{
m_precordset_access->addnew ();
for (int i = 0; i < m_precordset_sql->fields->count; i++)
{
Vvalue = M_precordset_sql->getcollect (_ variant_t ((long) i));
M_precordset_access->putcollect (_variant_t ((long) i), vvalue);
}
M_precordset_access->update ();
M_precordset_sql->movenext ();
The above is a description of the access that SQL Server data is copied to, and hope you get something.
The above is a description of the access that SQL Server data is copied into, hopefully giving you some help in this regard.