Recent content by deepakpar

Hi, The Excel file name will change, but the column names and the directory structure will remain the same. I can import the data by specifying each Excel file name but I have hundreds of that so I wanted to know if there is a shortcut (extreme layman terms, something like linking an entire...

Hi, I am a beginner in VB and I'm trying to automatically update a single Access database from a number of Excel files (with different names). Is there any easy way to do this? thanks!