I am using Access 2010,
is that possible to let users to open a Excel file and then select what columns in the file and writing to current access tables ?
For example, I open Excel A and it contains 3 columns, I just select column 1 and 2 data to write in current Table A fields B & C.
If yes, could you please advise how to do that by using VBA in Access 2010 ?
Thanks a lot !
Thanks & Regards,