Chapter Summary

This chapter has shown you how to programmatically create Microsoft Access tables by using ActiveX Data Objects. You learned how to add fields to your tables and define field data types. You found out how to list both tables and fields, and investigate their properties. In addition to creating new tables from scratch, you discovered how to work with linked tables. You also learned how to copy tables and transfer data from a Microsoft Excel spreadsheet to an Access table.

The next chapter will demonstrate how to create indexes and set up table relationships from your VBA code by using ADOX objects.

Chapter 12

0 0

Post a comment