work in excel, keep data in access

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

Guest

I have an excel file, for example
job country code
111 albany 11
111 albany 12

I want to get this data in access, then we want to delete the content of the
excel file, lets say in another day we want to put something else in the
excel file and delete the previous
222 bulgary 55

But I want to keep in access ALL the records
111 albany 11
111 albany 12
222 bulgary 55

the final "result" must be a report with parameter on job;
I have created a link between excel and access and I have built the report
but the access table/query/report always reflects the last content from the
excel file.
How do I do this programmatically? How do I add all the records in access?
Please be explicit, I have no experience in access.

Thank you
 
Hi Dany,

I'm not quite sure what you want to do.

Linking the worksheet as an Access table means that all changes you make
to the data in the worksheet are reflected in the linked table, so if
you delete the existing data and enter new data as in your example, the
old data will not appear in Access. This is because with a linked table
there is no data stored in Access: it is all taken direct from the
worksheeet.

So maybe what you need is to have one ordinary Access table, to store
the data, and a second table linked to the worksheet. And also an Append
query that appends data from that linked table to the first table. Then,
every time the Excel data is deleted and new data entered, run the
Append query to copy the new records to the Access table.
 
Back
Top