Recent content by mayasak

Thank you all for this discussion. This is what I'm doing exactly: I pull the data from a website to MS Access daily. The imported table names are long and have spaces/slashes. The number of imported files is 10 with 6 tables in each file. The data should be cleaned, recoded where necessary...

Hi, I have an ms access database with 6 tables. Table names are long and have spaces/slashes. I need to rename the tables every day so that it's shorter and has no spaces or slashes as below: table 123/abc 2022 --> table123 any ideas if this can be done dynamically(automated) will be...

Hi all, I'm so excited to be a member of this group. I'm totally new to Access and I'm eager to learn as much as I can so that I can use it.