To give you some back ground to the work and what is required. We have a form which displays records from 3 tables. The Form consists of 2 tabs with information on the two tabs coming from three separate tables. The first tab comes from one table. The second tab comes from two related tables.
What I need to done is the creation some buttons to import and export data to and from a Spreadhseet.
The following are the details of the buttons:
One button : Would allow the users to import data from a number fields on a Spreadsheet into the record that is currently open on the form.( 5-6 fields in 3 tables)
The second: Would be along the same lines. It would allow users to import data from a separate Spreadsheet into different fields.(again 5-6 fileds in 3 tables)
The third button would export data from the fields of the current record displayed on the form that is open to a preformatted spreadsheet. (Maximum 10 fields)
The version of access and Excel used will be 20002.