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

7. External Programs and Data > 70. Create Access Tables from Outside Access

Create Access Tables from Outside Access

You don’t have to be in Access to use Access.

Here’s the scenario: you have an Excel solution that needs to populate an Access table. The table will be a new table in the database. You might think the table needs to exist before you can populate it via ADO or some other means, so you manually create the table and then go back to Excel and run the routine that populates the table.

Actually, you don’t have to go to Access and create the table. Just create it directly from code while in Excel. It’s a simple matter, really; you just need to work with the ADOX library.

In Excel, set a reference to ADOX by using the Tools References menu and setting the references in the References dialog box, as shown in Figure 7-49.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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