Hi All,
Question on best practices.
I have four raw files that feed a customer_master database. I will be updating these files at least once a week, and potentially within that week, as necessary.
I have a spot on my C drive that I always save the most current file, that I use to currently import into access. I'd like to be able to just updated that file, save it with the same filename/location/column headers and just roll with it. Only that that is new in this file is new records will be added to the bottom. Column headers, sheet name, etc will always be the same.
Will I see any performance issues? Corruption? Other issues that are foreseeable?
Thanks,
Question on best practices.
I have four raw files that feed a customer_master database. I will be updating these files at least once a week, and potentially within that week, as necessary.
I have a spot on my C drive that I always save the most current file, that I use to currently import into access. I'd like to be able to just updated that file, save it with the same filename/location/column headers and just roll with it. Only that that is new in this file is new records will be added to the bottom. Column headers, sheet name, etc will always be the same.
Will I see any performance issues? Corruption? Other issues that are foreseeable?
Thanks,
