Step 2 Connect Excel

Now that you've set up the ODBC connection, let's get some data! To connect Excel, watch the video or continue reading below:

Open Excel and select the Data tab.
Select Get Data on the left side of the tool bar.
Select From Other Sources.
Select From ODBC.
In the new window, select "Walmart BI Link" in the drop-down menu.
Under Advanced Options, enter an SQL statement that aggregates the data.

Please refer to our Common Use SQL page for sample SQL statements.
Import the data using your preferred options.

📘
When new tables are released, repeat the steps above to add the new tables to your available data sets.

Disclaimer

Your use of this documentation is at your own discretion and risk. To the maximum extent permitted by law, the data, documentation and all related software, components, and support are provided by Walmart on an ‘as-is’ and ‘as available’ basis without any warranties of any kind, and Walmart expressly disclaims any and all express and implied warranties, including, but not limited to, warranties of merchantability, fitness for a particular purpose, title, non-infringement, non-interference, and warranties arising from a course of dealing. You acknowledge that Walmart does not warrant that the data will be uninterrupted, timely, secure, or error-free. Walmart may modify and delete the documentation in its sole discretion and without notice.

In no event shall Walmart be liable to you or any third parties for any damages whatsoever, including, without limitation, those resulting from loss of use, damage to your computer system, loss of data or profits, or any liability arising out of or in connection with the use of the data, documentation, software, components, or support.

📘When new tables are released, repeat the steps above to add the new tables to your available data sets.

📘
When new tables are released, repeat the steps above to add the new tables to your available data sets.