Databases
StackOverflow2013
Postsdbo
POExcel to SQL direct import error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExcel to SQL direct import error
    primarykey
    data
    text
    <p>Working for a considerable time on cracking some sales data, I came across an error which started to bug me for so real, eating my time of work. After so much of an effort, I was so fed up and nearly to give up on un-importable records.</p> <p>The scenario:</p> <ol> <li><p>Bulk sales data comes on txt/csv format needs to be imported to SQL database and then matched with Address History information available on a combination of tables by verifying strings directly from field to field.</p></li> <li><p>If codes matched, need to run a script to update few tables with data. If not matched, need to insert a whole bunch of data in to different tables to create ID which requires for the final sales import.</p></li> <li><p>Most of the was matching, except for few which was giving the trouble. I just needed to import those to history tables. Then started the problems, even though, I updated them, i couldn't match them.</p></li> </ol> <p>After some much of frustrated hours, I just asked my girl-friend to check when there any error in the string, I worked with.</p> <p>The string is "Bramhall Stockport" to be matched to "Bramhall   Stockport". For SQL script, these two strings are not matching.</p> <p>I bet if you copy and paste on your table this would match, coz now this is txt format.</p> <p>Then, Ana figured the error (She is not a computer geek, Architecture Masters), by simply coping and pasting on Microsoft Word 2007.</p> <p>Screenshot: <a href="http://www.contentbcc.com/Anushka/sql_xls.png" rel="nofollow noreferrer">http://www.contentbcc.com/Anushka/sql_xls.png</a></p> <p>Do you see the difference? First is in the txt/csv file and second on the SQL table.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKush
    1. USKush
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POExcel to SQL direct import error
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis special character is, Degree ° 0176 (ASCII)
      singulars
      1. POExcel to SQL direct import error
      1. USKush
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload