SQL Server: How to Avoid Data Loss During Migration From MS Excel (connectsql.blogspot.com)

submitted by lionofdezertlionofdezert(1110) 1 year, 3 months ago

While importing data from excel sheet, keep in mind that, SQL Server export/import utility look into first row of your data in excel sheet to guess data types of different columns. Problem occurs when we want to import columns, which contains both numeric and character data.

add a comment |category: |Views: 15

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story