Search results

I understood the reading part, However I can't edit the files I receive how can I make the code to write the date into a field say DATE in the database table once file is imported ?

Hello, I receive multiple .txt files everyday, The import code is working fine. I have been looking for examples to see how I can do the below though I am not sure if it can be done, Any guidance is much appreciated. The First row in every file is the date as below: HEADER;2021051701...

I am just learning databases now so I understand the first part you said and it makes sense but I didn't get the delete date part. Could you explain so may be I can try that ?

Thank you, It worked !!!

Ok so here's what I have done: I have a Monthly_Report database which has a table rawdata linked to DataRep database. I need to back up the database and then delete some data from rawdata table So I did the below: Created back up of Monthly_Report database Created back up of DataRep database...

So I created the back up of both the database and the linked table database. But when I delete the data in the database it still is being deleted from the back up database

Hi All. I am new to access so not sure if this is normal but I am creating the backup of a database using Save Database As Back Up Database as I have to delete some data. But when I check the data gets deleted from the back up database as well. How can I create a backup without the data being...

Relinking the tables did the work. Now I can edit without affecting the FE db. Thanks for your help.

Thank you so much for replying. The database is not split but a few tables in it are linked to 2 other databases. I can see the path to it as well. Any suggestions on how I can proceed to make changes without affecting the original dB?

Hi, I have been asked to look at a database and am not very much experienced with Access. I am facing the same issue. I copied a database to desktop and made changes which have been reflected on the original database in the drive. I see the solution offered is to re link front end and back end...