Dandandanf
New member
- Local time
- Today, 00:27
- Joined
- May 25, 2020
- Messages
- 1
Hi, really hoping someone with some experience can advise.
I’m trying to import around 500 excel files into access each one being records from a particular day. I need also need to add a date field to the access table. The excel files contain the date reference in the file name only.
I’m not necessarily looking for the code to do this, only what steps you would recommend as the most efficient way of doing this. I’m a beginner at access but keen to learn and ok at vba.
Any suggestions would be much appreciate as I’m out of my depth at the moment.
thanks
dan
I’m trying to import around 500 excel files into access each one being records from a particular day. I need also need to add a date field to the access table. The excel files contain the date reference in the file name only.
I’m not necessarily looking for the code to do this, only what steps you would recommend as the most efficient way of doing this. I’m a beginner at access but keen to learn and ok at vba.
Any suggestions would be much appreciate as I’m out of my depth at the moment.
thanks
dan