Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to copy SQL Server data to Access", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "how to copy SQL Server data to Access" bar!

What we mainly tell you today is the actual operation steps of copying SQL Server data to the Access database, copying some data from the SQL Server database to the Access database, the main structure of the table is the same, do not mention openrowset, because the Access file and SQL Server are not on the same machine.

The initial idea is to use two recordset, one to fetch data from SQL and the other to insert data into Access.

Because the table has more fields, it has to use a loop.

While (! int _ Recordsetsql-> adoEOF) {mroompRecordsetters access-> AddNew (); for (int I = 0; I

Fields- > Count; iSql +) {vValue = mSecretpRecordsetSecretsql-> GetCollect (_ variant_t ((long) I)); mSecretpRecordsetaccessa-> PutCollect (_ variant_t ((long) I), vValue);} mcorrecpRecordsetaccesssql-> Update (); mSecretpRecordsetaccesssql-> MoveNext () } Thank you for your reading. The above is the content of "how to copy SQL Server data to Access". After the study of this article, I believe you have a deeper understanding of how SQL Server data is copied to Access, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.