[scouse13]

hi all
within an excel workbook i have various worksheets were i enter data, the final worksheet collects all this data and displays it all together.
i would like to be able to save all this data to an access database i have tried using the external data button in access and set up the database to import this sheet, which is fine, but when the sheet in excel is cleared and new data is entered, when i try to import this into the access database, it just overwrites the previous entry instead of entering it in a new row?

also rather than having to use the external data ribbon in access can i use a command button on the final worksheet in excel with code to simplify the task or is there a totally different way of acheiving the above objective without using access

many thanks

[etaf]

can you link it to a temporary table and then do an update query to bring the data into a final table, which will then grow each time you run the update...

[Rockn]

Do you really need to use Excel at all? If you want all of the data in tables in Access you can manipulate that data and still display it in reports like you would in Excel. Data in Access will be far cleaner with less duplication than you could ever achieve in Excel as long as your data input process and forms are created correctly. Sounds like duplication of effort using two applications to do one job.

[OBP]

Do you have to do a regular Import of Excel data in to Access?
If so then you import the data in to a "Temporary" table and Append the data to the real table and then delete the records from the Temporary table with a delete query.