×

Data source write back and offline data editing and storage in a spreadsheet

  • US 7,225,189 B1
  • Filed: 02/19/2004
  • Issued: 05/29/2007
  • Est. Priority Date: 02/19/2004
  • Status: Active Grant
First Claim
Patent Images

1. A method of bi-directional communication between a spreadsheet application and a database, comprising:

  • connecting a spreadsheet to a data source;

    importing via the spreadsheet application data to the spreadsheet from the data source;

    modifying the imported data in the spreadsheetpublishing data from the spreadsheet to the data source via the spreadsheet application;

    determining whether publishing the data to the data source creates a conflict with data previously published to the data source via the spreadsheet application; and

    storing the data at the data source including writing via the spreadsheet application any changes made to the data in the spreadsheet over corresponding data previously stored at the data source;

    whereby publishing the data to the data source includes publishing imported data back to the data source and writing the modified imported data over the data in the data source from which the data was imported to the spreadsheet.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×