Forum Discussion
Connect to most recent SQLlite.db in Folder
Hi,
I hope someone can help me :)
I want to connect to the most recent SQLite.db in my backup folder. Problem is, those system generated backups a named a certain way (with the date attached):
->\Db-folder\file_2019_22_02.db
->\Db-folder\file_2019_21_02.db
->\Db-folder\file_2019_20_02.db
So, I guess you see where this is going. I need to find a way to always connect to the most recent db. Connecting to the folder, like with csv files, does not work. Connecting to a SQLite.db does work, btw.
Files older than three days are deleted, if this is relevant.
Thank you 😊
2 Replies
- v-chuncz-msftCommunity Support
- whereismydataResolver IV
thank you very much for taking time to respond to my question and sorry for my late respone.
I tried applying your proposed solution but couldn't make it work.
I now use a script to copy and rename the latest .db to another folder.
thank you