Sec3Op41514
New member
- Local time
- Today, 12:20
- Joined
- Oct 6, 2023
- Messages
- 6
Hello! New user here, I am looking for a way to hit a button and add a file to a table.
The file name changes constantly based on the date and time so i cannot use a default file location, it HAS to be a browser. I can attach a sample csv to show what the exported file looks like.
It either needs to append to a current table, OR the button can delete the table, then recreate it with the exact same name when importing, because the import file will always have the same data as it's predecessor, just with more new stuff added on. The table would be called "Catalog ID Imports"!
Thanks for all the help! It just seems to be super confusing and I am just learning how to use access vba.
~I'm a noob but i'm like a sponge, ready to learn!~
Edit: just to state i have tried many things I've found on internet and they all seem catered to something specific and i'm just not knowledgeable enough to figure out how to change those to my needs... i appreciate any and all help given though!
The file name changes constantly based on the date and time so i cannot use a default file location, it HAS to be a browser. I can attach a sample csv to show what the exported file looks like.
It either needs to append to a current table, OR the button can delete the table, then recreate it with the exact same name when importing, because the import file will always have the same data as it's predecessor, just with more new stuff added on. The table would be called "Catalog ID Imports"!
Thanks for all the help! It just seems to be super confusing and I am just learning how to use access vba.
~I'm a noob but i'm like a sponge, ready to learn!~
Edit: just to state i have tried many things I've found on internet and they all seem catered to something specific and i'm just not knowledgeable enough to figure out how to change those to my needs... i appreciate any and all help given though!