Can anyone have sample application for Import and Export Excel file data to SQLCE database table.
I am using dot net 2008 to create an application which can work on Windows CE devices.
I created the application with database as MyData.SDF. inside i created Product table with Itemcode,Description,Qty,Expirydate and price.
Now i have an excel file with data such as Itemcode,Description,Qty,Expirydate and price.The excel file is copied to my Windows CE device application path.
While i am trying the read the Excel file from the device application path, it gives me error. File not found. Can some one suggest me any other methods to complete these import and export process. your help will be highly appreciated.