Migrate Data from MS Excel to SQLite and Back Again

In this episode, we're going to take a round-trip, migrating Excel data to a SQLite database, then back again into Excel as a transformed output. This simple method of moving data can improve your ability to analyze data, especially when they need to be joined in complex ways that are better suited to SQL. Using SQLite, you can not only store data in a better, more rigorous format than Excel or CSV, but you can also leverage powerful SQL capabilities that a relational database management system can provide.. ..all on your desktop! Using local SQLite capabilities means that you can perform all of these operations with no network or internet connections. You can collect data in the field or work on big transformations where networks are spotty or non-existent, and you can leverage the power of your desktop or laptop along with SQL.

Related Videos:
Getting Started with SQLite for Python
   • Getting Started with SQLite for Python  
How to Execute SQL from a File on SqLite Using Python
   • How to Execute SQL from a File on SqLite U...  
How to Select Data from SQLite
   • How to Select Data from SQLite  
How to Output HTML from SQLite
   • How to Output HTML from SQLite  
Migrate Data from MS Excel to SQLite and Back Again
You are watching this video now!
How to Use Dates in SQLite
   • How to Use Dates in SQLite  
How to Create a Delimited Field in your SQLite Query with Python
   • How to Create a Delimited Field in your SQ...  
How to Make an Interactive Map Using Python and SQLite Data
   • How to Make an Interactive Map Using Pytho...  

Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html

Want my team to do a project for you? Let's get to it!
https://buy.billzone.com/smdeprojects...

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

  / mackenziedataengineering  

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


#dataengineering #datascience #sqlite #python