Hi
I'm using MS-Office 2003 and I haven't used VBA in awhile (just got introduced with an Excel project I've been working on!).
The Excel document I've created (with tons of assistance from Skip - big thanks) is required to be automated. The Excel workbook is fine because the data is coming from Access and I used MSQuery so it autofills on open.
The source of the data will be saved in .txt format but how do I write code to:
- auto populate Access at certain time of day
- have whatever is uploaded to overwrite only those records in the table matching what is being uploaded
- how do I control format of what is being imported...dates from a .txt file are always a problem
Thanks for any assistance!
I'm using MS-Office 2003 and I haven't used VBA in awhile (just got introduced with an Excel project I've been working on!).
The Excel document I've created (with tons of assistance from Skip - big thanks) is required to be automated. The Excel workbook is fine because the data is coming from Access and I used MSQuery so it autofills on open.
The source of the data will be saved in .txt format but how do I write code to:
- auto populate Access at certain time of day
- have whatever is uploaded to overwrite only those records in the table matching what is being uploaded
- how do I control format of what is being imported...dates from a .txt file are always a problem
Thanks for any assistance!