• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Controlling a Database from ... > Using ADO to Move Data from Excel to...

Using ADO to Move Data from Excel to a Database

There are some minor differences between DAO and ADO when it comes to modifying data. This section examines how you might structure your code using ADO to perform the two tasks discussed in the prior section, adding records and editing existing records.

Using ADO to Add Records

As before, the intent is to scan the data on a worksheet, picking up the names and share prices of stocks and copying them to a database table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint