Hey guys-
I have a file that I am importing into my database. The original file's column headings are difficult to understand and work with. I'd like to change them to something more manageable. However, I cannot' change the original file's headings, and this is something I will be importing new file on a daily basis. So, I need to have the column headings changed once they get imported into Access. The original file will never change format from day to day- so it's consistent each time.
What's the easiest way to change the column headings automatically once the data is imported?
Side question- The original file is in a DBF2 (I think) format. What's the easiest way to import this directly into Access?
Thanks guys!
I have a file that I am importing into my database. The original file's column headings are difficult to understand and work with. I'd like to change them to something more manageable. However, I cannot' change the original file's headings, and this is something I will be importing new file on a daily basis. So, I need to have the column headings changed once they get imported into Access. The original file will never change format from day to day- so it's consistent each time.
What's the easiest way to change the column headings automatically once the data is imported?
Side question- The original file is in a DBF2 (I think) format. What's the easiest way to import this directly into Access?
Thanks guys!