I am trying to import an excel sheet into sql server table. I have written the data access layer.
However I am unable to use Microsoft.Jet.OLEDB.4.0 and I want to use Microsoft.office.interop.excel.
This can be added as reference and imported to bin.
How to get the exact file path for the excel via command line.
any suggestion or code snippet pleasE?