Append Excel Records to Access Database
Posted by John on May 29, 2001 11:41 AM
I have setup a database in Access and would like to import records from an Excel spreadsheet.
1. Have setup a template to create records in an excel database file.
2. Would like to either export the records to Access then delete the records in Excel
3. Or retrieve the records from Access and then delete the records in Excel.
Problem: The Excel database is updated by various users and not all of them have
Access installed. That's why I have used the Template in Excel to gather the data in Excel.
Only one user will have Access installed. He/she will be responsible for gathering all the data and create reports from the database.
At the moment, I am able to use the facility from Excel "Convert to Access" to create a new table in Access but it gives me error messages when I try to import the data into an existing table even though the table itself (created by first import, as well as creating a blank table with identical fields to the Excel Database).
Can this be accomplished through macros and if so please provide some advice on this.