Hi All,
Im kind of looking for a way to automate (make it easyier) something that i have to do on a regular daily basis.
I have to import data from an Excel file(s) to a specific table in my database.
I would like to be able to do this through a command button within a form. So when i click on the button it would ask me to locate the excel file i would like to import and then copy only the Columns A and B data from the excel file to a table called tblTEST in my database automatically.
Is this easy enough to do? I have tried playing with some code but im not having any luck.
Can someone help me?
Regards
Sam
Im kind of looking for a way to automate (make it easyier) something that i have to do on a regular daily basis.
I have to import data from an Excel file(s) to a specific table in my database.
I would like to be able to do this through a command button within a form. So when i click on the button it would ask me to locate the excel file i would like to import and then copy only the Columns A and B data from the excel file to a table called tblTEST in my database automatically.
Is this easy enough to do? I have tried playing with some code but im not having any luck.
Can someone help me?
Regards
Sam