Basic DIY Intranet: Read from Excel files

Channel:
United Kingdom Geb Systems
Subscribers:
567
Published on ● Video Link: https://www.youtube.com/watch?v=3AClIyRkpGQ


Duration: 11:11
44 views
0

How to use your excel file(s) as the database backend... kinda. A demo how to read from Excel file sheet via the ODBC connector with the help of PHP and XAMPP. This is slowly going to get more and more complex. Especially when I combine few sheets (or even excel files) to provide a more sophisticated / useful intranet that will allow you to quickly digest and process TONS of data the way you need / want it !

This was recorded after midnight so I am rambling quite a bit :) I called SQLITE a database server so that is for sure a semi-broken overworked night mind at play.

You can download the entire project here:

http://db4you.co.uk/uploads/intranet_p3.zip



Other Videos By Geb Systems


2022-08-12Suriouc: Excel2Web getting closer
2022-08-06Constructor: Excel to Web & SQL Schema?
2022-07-31Web Interface over Excel file
2022-07-25SQLite vs Excel for STD as database
2022-07-19Smiling Troll Distillery Limited (Incorporated)
2022-07-17DIY Intranet: CSV2SQLITE Tool
2022-07-14Basic DIY Intranet: Simple Barcode Generation Demo
2022-07-12Arduino Mp3 Player... 2nd UPDATE
2022-07-10Basic DIY Intranet: Going deeper
2022-07-09SQL INNER JOIN on two CSV files
2022-07-07Basic DIY Intranet: Read from Excel files
2022-07-05Basic DIY Intranet: Web Server (XAMPP)
2022-07-05Basic DIY Intranet Part 2: Database Connect Function
2022-07-03Din rail for Arduino Projects
2022-07-02Basic Introduction to a DIY PHP Intranet + Code
2022-06-18RS485 and TCPIP at the same time over RJ45
2022-06-17RS485 toplogy fun with four RJ45 splitters
2022-06-12RJ45 splitter used for a DIY modbus "network"
2022-06-10Arduino Modbus using Din Terminal Blocks
2022-06-03Arduino ModBus: Ethernet Cable Splitter
2022-06-03GebWMS Location Configuration


Tags:
php
intranet
xampp