Advanced VBA exercises on LINKING TO DATA

This page lists the 3 exercises about Linking to data in Advanced VBA on our website:

Software: Advanced VBA
Version: Any MS Office versions
Topic: Linking to data
Level: Average difficulty
Course: Advanced VBA
Exercise: Use ADO in VBA to add data to an Access database from an Excel workbook.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: Linking to data
Level: Average difficulty
Course: Advanced VBA
Exercise: Use ADO to extract a table of data from an Access database into a new Excel worksheet.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: Linking to data
Level: Average difficulty
Course: Advanced VBA
Exercise: Create an input form for Beatles, linking Excel to Access using ADO, then read Beatles back into an array using REDIM PRESERVE.

Go to exercise ...

You can search our full list of VBA exercises here, or why not have a look at our other VBA training resources?

This page has 0 threads Add post