I want to convert an .xls file to access database.i have tried using docmd.transferspreadsheet but it failed.so please help me and tell me other ways of doing it
thanx in advance
Printable View
I want to convert an .xls file to access database.i have tried using docmd.transferspreadsheet but it failed.so please help me and tell me other ways of doing it
thanx in advance
Try to import *.xls to *.mdb using Insert - Table - Import Table in Access.
Vlad