Create a Database Table from any Spreadsheet

Using this program a database table can be made out of any Spreadsheet file.  The name of the Database table is the same name as the title of the .xls file.  If you name your spreadsheet "products" dot xls the table name created in the database is called "products".    The contents of a relational Database consist of fields.  These fields types are either numbers, dates or  text.  A table in a Relational Database consists of  rows and columns.   Each column (vertical ) has it own  associated type. 

In MYSQL  some of the valid data types are date, integer, decimals and text.  Type checking in MYSQL is very strict!   Alpha characters  (a-Z)  are not allowed in integer or decimal fields.  Date formats are not allowed in integer fields but can be inserted into a text field.  

 One reason to use MW Software's entry screens is the data is "sanitized" before it is entered into the Database.  There is several ways to enter a state.  Colorado could be entered as CO, COLO or any number of other ways.  Using MW Software's entry screen with state pick list  there is only one way to enter a states name in the Database.

 The one restriction  placed on how the Spreadsheet looks is the first row of the Spreadsheet.   Assume that the data in the Spreadsheet is a list products.  Each column in the first row of the Spreadsheet is the descriptive name of the Data.  If the column type is a date type then the first row of the first column should be named something like "Oder Date" or "Transaction Date" .  Using the product example  the second Column is "Region" and third column is Rep or Representative  and so on.  For a more detailed view of the instructions, Please go to the Instructions link.

Here is how the spreadsheet should look like.  Also this is the Mysql CREATE TABLE command.  Notice the first row is the name of each column both in the spreadsheet and in the CREATE script.