Connecting Excel to Lyftrondata
In this article, we will show you how to connect Excel to Lyftrondata
NOTE: Lyftrondata emulates Microsoft SQL Server, therefore a built-in SQL Server provider is sufficient to connect to Lyftrondata.
Excel documentation is available in Microsoft online help.
Step 1: Open Excel and select SQL Server as data source
If you have not started the Excel yet, open it. Under the "Data" section, select the "From Other Sources" and choose From SQL Server option.
A new dialog opens.
Step 2: Enter server name taken from Lyftrondata Dashboard
Into a "Server name" textbox enter the Lyftrondata server name taken from Lyftrondata Dashboard. Choose appropriate Log on credentials.
Step 3: Choose a database and desired tables or views
Choose a database and desired tables or views to import. To select multiple tables, check the "Enable selection of multiple tables" option.
Step 4: Save data connection
Choose an option to save your data connection.
Step 5: Choose how you want to use data in your workbook
Choose how you want to use data in your workbook and which worksheet you would like to use as a target for data import:
Step 6: Wait for import to finish and start exploring your data
Depending on the amount of data you import it may take a while to copy the required data into your Excel worksheet. When data import completes, you can start exploring your data.
That concludes the steps required to connect and use Excel with Lyftrondata.