The attached application appends data from a MS-Excel Table to an MS-Access Database. The Control Panel sheet is used to configure the download. On the Control Panel sheet, you tell the program the directory in which the database is located, the database name, the Excel Table name and the Access Table name. You then provide of list of Excel Table header names and corresponding Access Table field names.
Clicking on the Make XML button on the spreadsheet does a validation check to make sure that the database, tables and fields exist and creates an XML instruction file in the same directory with the application. Creation of the XML file is a one-time exercise repeated only if table names, field names, database names or locations are changed.
The attached file contains instructions and a sample database.
Bookmarks