Access Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The Import Wizard in Access works well for one of my applications, but I want
to replicate this functionality in VBA. In other words, I want to know the
code that steps through all of the options in the wizard for File/Get
External Data/Import from Excel. The options are: (1) specify Excel file
name, (2) specify worksheet name, (3) first row contains column headings, (4)
store in new table, (5) select fields, (6) assign primary key, (7) specify
table name.

Can I automate this in VBA, or do I have to keep using the wizard?

Thanks!
 
You can automate it. However,

1. Using the wizard should be much easier
2. All of the wizards are contained in a library database. There is a
way to display the forms & code in them, however when I just snooped
around myself, I couldn't figure it out. The wizards aren't top secret
so it shouldn't be too difficult to view the source.
 
Back
Top