Import Excel into SQL using SSMS

I’ve started working with PowerBI Desktop these days for data visualization.  It didn’t take long to hit some limits on portability when using an Excel sheet as a data source.

So, I decided to import the Excel sheets into SQL, and then connect PowerBI Desktop to the SQL database.

  • First, I created a new SQL database.

1.png

  • Then, right-click the database, Tasks > Import Data

2_001.png

  • Select the Excel sheet you wish to import and the version.

3.png

  • For destination, select SQL Server Native Client 11.0 and specify the SQL Server instance, authentication method and database

4.png

  • You then have the option of editing mappings and previewing the import.
  • Then proceed with the import.

Once the import was complete, I connected a new PowerBI Desktop to my database.

6.png

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s