How to Download PowerBall Numbers, Convert and Load into SQL Server using Bulk Insert.
In this video, we will use DATA.GOV and download the PowerBall winning numbers. After we download the data, we will use Microsoft EXCEL, VBA language to convert the raw data, into a data format that will be easy to load into SQL Server.
We will learn how to use BULK INSERT, to load all this data into SQL Server.
To discover the benefits of storing Powerball numbers in a database, such as faster data analysis and easier retrieval.
use Powerball numbers in a database to perform statistical analysis
To learn how to use scripts and automation to make the process of downloading and loading Powerball numbers more efficient.
GITHUB:
https://github.com/softwareNuggets/Do...
Table of Contents
00:00 Begin
00:14 Data.gov -- download powerball winning numbers
00:58 Validate numbers we just downloaded
02:20 Remove un-needed column and learn about data
03:13 rename file from CSV to XLSM
03:49 Load VBA editor
04:04 Write sub main() to convert string data to individual numbers
06:57 continue sub main(), use while loop, learn split function
10:44 write sub buildFile(), write powerball winning numbers into a file
13:30 create SQL Server table, use BULK INSERT
14:40 final thoughts.
#softwarenuggets, powerball, bulk insert