Etxezarreta
Member
- Local time
- Today, 11:19
- Joined
- Apr 13, 2020
- Messages
- 175
Hello everyone,
I have been facing the same problem: and I am a bit ashamed to say that I am not sure about the solution you all try to make us understand.
=> Let say the DB we use (queries, records etc..) is named Main_DB. It is in Folder_Main_DB
- The CSV file is called File_CSV. It is in Folder_CSV
- The master Access is called MasterCopy_DB: it is in Folder_MasterCopy_DB
- The slave Access is called SlaveCopy_DB: it is in Folder_SlaveCopy_DB
=>Questions:
- You create a table in MasterCopy_DB linked to File_CSV correct?
- Then with VBA code you give the order from Main_DB to create a copy of MasterCopy_DB in Folder_SlaveCopy_DB, called SlaveCopy_DB?
- Then in SlaveCopy_DB, I check whatever I need to still from Main_DB
- If it is ok, I transfer the data from SlaveCopy_DB to Main_DB ?
- Then I get rid of SlaveCopy_DB , still from Main_DB?
Sorry if I make you repeat all over again, I really need to be sure of the correct process.
Thanks again.
Etxe.
Etxe.
I have been facing the same problem: and I am a bit ashamed to say that I am not sure about the solution you all try to make us understand.
=> Let say the DB we use (queries, records etc..) is named Main_DB. It is in Folder_Main_DB
- The CSV file is called File_CSV. It is in Folder_CSV
- The master Access is called MasterCopy_DB: it is in Folder_MasterCopy_DB
- The slave Access is called SlaveCopy_DB: it is in Folder_SlaveCopy_DB
=>Questions:
- You create a table in MasterCopy_DB linked to File_CSV correct?
- Then with VBA code you give the order from Main_DB to create a copy of MasterCopy_DB in Folder_SlaveCopy_DB, called SlaveCopy_DB?
- Then in SlaveCopy_DB, I check whatever I need to still from Main_DB
- If it is ok, I transfer the data from SlaveCopy_DB to Main_DB ?
- Then I get rid of SlaveCopy_DB , still from Main_DB?
Sorry if I make you repeat all over again, I really need to be sure of the correct process.
Thanks again.
Etxe.
Thank you very much, this is an extremely useful work.Sorry for the delay. I had started a sample db for this function a while back so I finished it and added instructions. It is a little more complicated than it actually needs to be but it is also more flexible and includes some other features you might find useful. See how it works for you.
Etxe.