none
excel file to sdf file conversion

    Question



  • I want to pull data from excel file to windows mobile ce 5.0 device. Is it possible to pull data from excel file placed in device or I need to convert it to sdf file if yes then how?
    actually my requirement is like users will paste file with latest data in windows ce device.And I have to pull data in latest file.I tryied with excel file but after copyin my documentd folder of device it is not opening in CE device.

    what to do to achive this or is there ant file type which will open in device.

    • Edited by anuja777 Monday, July 06, 2009 8:33 AM
    Friday, July 03, 2009 9:02 AM

Answers

  • Hi anuja77,

    We can dataset.readxml to retrieve data from excel. Here is a sample to read excel:

    http://www.codeproject.com/KB/grid/DataSetMagic.aspx

     

    Once we retrieve the data, we can insert it to sdf database.

    If you are working CF 2.0, we can use SqlCeDataAdapter.Update to insert data to database.

    Best regards,

    Guang-Ming Bian - MSFT


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Tuesday, July 07, 2009 10:54 AM

All replies