Method and apparatus for loading data from a spreadsheet to a relational database table
First Claim
1. A computer implemented method for transferring data from a specified spreadsheet having a name, rows and colunms to a relational database table, said method comprising the steps of:
- receiving said specified spreadsheet at a given location;
assigning a name to said relational database table that is derived from said spreadsheet name;
creating names for respective colunms of said table from the contents of a first row of said specified spreadsheet;
deriving data types for respective colunms of said table from the contents of a second row of said specified spreadsheet; and
loading data into locations of said table from respectively corresponding cells of said specified spreadsheet, wherein said data loaded into locations of said table is selectively combined in a document, at said given location where said specified spreadsheet has been received, with other information that has not been contained in a spreadsheet; and
said transfer of data requires completion of an authentication procedure to affirm that said specified spreadsheet may be uploaded into a repository at said location that is associated with said relational database table, wherein said specified spreadsheet contains identification information for use in said authentication procedure.
6 Assignments
0 Petitions
Accused Products
Abstract
One embodiment of the invention is directed to a method for transferring data from a specified spreadsheet, having a name, rows and colunms, to a relational database table. The method includes the steps of receiving the spreadsheet at a given location, assigning a name to the relational database table that is derived from the spreadsheet name, and creating names for colunms of the table from the contents of a first row of the spreadsheet. Data types for respective colunms of the table are derived from the contents of a second row of the spreadsheet. After creation of the table, data is loaded into locations of the table from respectively corresponding cells of the specified spreadsheet.
-
Citations
6 Claims
-
1. A computer implemented method for transferring data from a specified spreadsheet having a name, rows and colunms to a relational database table, said method comprising the steps of:
-
receiving said specified spreadsheet at a given location; assigning a name to said relational database table that is derived from said spreadsheet name; creating names for respective colunms of said table from the contents of a first row of said specified spreadsheet; deriving data types for respective colunms of said table from the contents of a second row of said specified spreadsheet; and loading data into locations of said table from respectively corresponding cells of said specified spreadsheet, wherein said data loaded into locations of said table is selectively combined in a document, at said given location where said specified spreadsheet has been received, with other information that has not been contained in a spreadsheet; and said transfer of data requires completion of an authentication procedure to affirm that said specified spreadsheet may be uploaded into a repository at said location that is associated with said relational database table, wherein said specified spreadsheet contains identification information for use in said authentication procedure. - View Dependent Claims (2, 3, 4, 5, 6)
-
Specification