I have a lot of Excel datasheet (in one file)
I want to batch input to Access
but I can't find a sample code to do it
the name of datasheet in access is same as in excel
is there any code of VBscript can do it?
maybe in access or excel vba?
or any simple software?