Creating a Table and Fields Using ADO
This chapter noted at the outset that ADO isn't well suited to creating new databases; its strength lies in moving data back and forth between a database and some other application such as Excel.
Therefore, if you're using Access and its Jet database engine as the database, it makes good sense to create your databases either using DAO (as shown in this chapter's prior sections) or directly with the database's user interface. If you're using another DBMS, such as SQL Server, it's far easier to use its interface to create the database.
However, after the database exists, ADO offers tools that are entirely appropriate for creating new tables, fields, and other structures. What follows is an example of how to ...
Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
