Importing a table in to SQL from a web-site or a spreadsheet using the muppix SQL tools
Background:
Importing raw data into SQL from text or CSV files often fails because SQL is very strict in its datatypes. The likelihood that some wrong character somewhere in the file can cause the whole import to fail and the error message is of little help. Its all or nothing.
The Muppix SQL table import tool calculates the datatypes from the raw data and generates the appropriate SQL code to ensure the table will import into SQL.
The steps are:
Background:
Importing raw data into SQL from text or CSV files often fails because SQL is very strict in its datatypes. The likelihood that some wrong character somewhere in the file can cause the whole import to fail and the error message is of little help. Its all or nothing.
The Muppix SQL table import tool calculates the datatypes from the raw data and generates the appropriate SQL code to ensure the table will import into SQL.
The steps are:
- Load up SQL Import Table tool spreadsheet
- Copy the table from a website or from another spreadsheet
- Cut/Paste the table into the [ImportTable]
- Enter the name of your table in the yellow cell, ie myinvestments
- Copy column A in [Results] tab & past into your SQL monitor :
- Run a normal SQL command:
- SELECT * FROM myinvestments WHERE Price > 300