Recent content by filiep

Ok thx I'll try it. Is there a possibilty to have a query that automaticly searches excel files in a folder and returns the result in a table? For example if where where to save the weekly table in seperate weekly excel files. Could a a query search these excel files and add the matching rows...

Sorry try to explain it: but we only want to keep the changes in VrStBasis and WerklEinde I mean that we only want to keep the rows where the date's in VrStBasis and WerklEinde are different then the week before. So if these are changed the whole row should be saved along with the previous...

every item can change but we only want to keep the changes in VrStBasis and WerklEinde. VrStBasis is the starting date. The WerklEinde is the date that the work is reported to be finished.

Thx for the reply. The sample is added in a zip file. The weekly table has 1670 rows. The data is a download from SAP where each line is an activity that someone has to do. The download is to excel and imported with a script into access. It deletes the previous table and replaces it with the...

Ok here's what I'm trying to do. We import data to a table on a weekly basis. We delete the table and replace the data. Most of the data is the same. It's date's, group names, ... Now we would like to save the weekly table and add a saved date. Then we would like a query that puts all the...

ok thx for the replies!

Hello, at work I want to complete the access database and therefore I donloades data from SAP to an xls file (attached). I'm trying to import the file to access 2007 and get a tabel like the result file i have attached. If it isn't possible then is it possible to join 2 tables where I want to...