How to Paste Microsoft Excel data to SQL Server

Excel

  1. In Excel, highlight and copy the data you want to paste into SQL.

SQL

  1. Create the table with the desired column names and give you table a name. *Make sure Identity Specification is Yes, so it will auto increment your Identity column.
  2. Find your table, and right click on it and choose Edit Top 200 Rows from the dialog-box.
  3. Right click on the empty row with the * sign and select paste from the dialog-box

enter image description here


Comments

Post a Comment

Popular posts from this blog

How to Make Windows Photo Viewer Your Default Image Viewer on Windows 10

Image
Windows 10 uses the new Photos app as your default image viewer, but many people still prefer the old Windows Photo Viewer. You can get Photo Viewer back in Windows 10, though. It’s just hidden. If you upgrade a PC running Windows 7 or 8.1 to Windows 10, Windows Photo Viewer will be available and you can set it as your default photo viewer if you want. However, if you perform a clean installation of Windows 10—or buy a PC with Windows 10 already on it—you can’t access Photo Viewer at all. The interesting thing is that Photo Viewer is still there. It’s just hidden and you’ll have to make a couple of Registry edits to have it show up. After you do that, you can then set it as your default photo viewer. The Problem For whatever reason, Microsoft opted not to include the Registry keys that enable access to Windows Photo Viewer on Windows 10. Those keys are kept in place if you upgrade from a previous version of Windows, but they aren’t created during the installation of Windows 10. Micro...
Read more

How to configure your Outlook GMail account

Image
Configuring the Outook Gmail settings. You can configure Outlook to handle your Gmail account as a POP3 or as an IMAP account. Depending on your choice, you have to enable the related account option in your Gmail account (Gmail Settings -> Forwarding and POP/IMAP). 1. From the main Outlook window, go to Tools -> Email Accounts. 2. Select to "Add a new e-mail account" and click on Next. 3. Select POP3 or IMAP (depending on your needs) for the Outlook email account type, then click on Next. There is no need to select the IMAP type, because the Gmail web based account will anyway keep a copy of all emails, just like an IMAP account would do. You will have to specify your Outlook Gmail settings, such as your Gmail username and password, Gmail server addresses, Gmail server ports and Outlook Gmail display name. Enter your Name (it can be anything, but remember this is going to be the name/text that people will see when you will send them an email via your Outlook Gmail accou...
Read more

B1SiteUser Password Reset and Recovery

Image
During the installation of the SAP Business One server software you are asked to set a password for the B1SiteUser. The days become months and the months become years before you need to use these credentials and don't remember the password. Fear not! There is an easy solution to reset it! Open up the "Service Manager" program from the start menu. The service manager starts minimized, so it may already be running. Check the notification area of your Windows taskbar for the blue and red icon. Double click the icon to bring up the settings window. Select the "License Manager" from the dropdown in the second box from the top. You want to click the "Settings" button. Now we see the license manager's settings. Find the button on the bottom of the window called "Configure Security". Resetting the B1SiteUser Password This will bring you to a webpage on your server. There might be some issues with web browsing on your server depending on security ...
Read more