Import excel files
I would like to check if an excel file showed up in a specific folder and process it into a table in access. How can I do this, is there a sample code I can use?
Import excel files
I would like to check if an excel file showed up in a specific folder and process it into a table in access. How can I do this, is there a sample code I can use?
This type of thing, where strPath is the full path to the file (you can hard-code it as well):
If Len(Dir(strPath)) > 0 Then