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 ?
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...
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...