Hi there,
I have created a macro to import data from MS Excel file into a table in MS Access database. Each time I have to import data from a different file. Therefore, I cannot predefine the path of the spreadsheet for data import. Is there a way I can prompt the user to punch in the location of the file for import?
Thanks,
Aarti Jobanputra
I have created a macro to import data from MS Excel file into a table in MS Access database. Each time I have to import data from a different file. Therefore, I cannot predefine the path of the spreadsheet for data import. Is there a way I can prompt the user to punch in the location of the file for import?
Thanks,
Aarti Jobanputra