Search Results for "import excel into sql"
Sort By:
Showing 25 open source projects for "import excel into sql"
View related business solutions-
Our Free Plans just got better! | Auth0 by OktaYou asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your secuirty. Auth0 now, thank yourself later.
-
Bright Data - All in One Platform for Proxies and Web ScrapingBright Data offers the highest quality proxies with automated session management, IP rotation, and advanced web unlocking technology. Enjoy reliable, fast performance with easy integration, a user-friendly dashboard, and enterprise-grade scaling. Powered by ethically-sourced residential IPs for seamless web scraping.
-
1
sq data wrangler
sq data wrangler
sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure... -
2
dsq
Commandline tool for running SQL queries against JSON, CSV, Excel
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. This is a CLI companion to DataStation (a GUI) for running SQL queries against data files. So if you want the GUI version of this, check out DataStation. -
3
A read-only JDBC driver for Java that uses Comma Separated Value (CSV) files as database tables. Ideal for writing data import programs and conversion programs.
-
4
GETL
ETL engine based on Groovy
P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with... -
Secure remote access solution to your private network, in the cloud or on-prem.OpenVPN is here to bring simple, flexible, and cost-effective secure remote access to companies of all sizes, regardless of where their resources are located.
-
5
Free VCF file to CSV or Excel converter
Excel VBA Script to convert VCF file with multiple entries to CSV file
This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has been written to support VCF 2.0, 2.1, 3.0 and 4.0 formatted files including those with printable encoding (MIME) and has been tested with bulk VCF files from Backupify, Google Contacts (Gmail... -
6
XML Editor/Validator/Designer with CAMV
CAM XML Editor for XML+JSON+Hibernate+SQL Open-XDX sponsored by Oracle
The CAM editor is the leading open source XML Editor/Validation/Schema toolset for rapidly building / deploying XML /JSON /Hibernate /SQL data /Forms applications. Visual WYSIWYG data design, rule entry wizards + drag & drop dictionary components. Will import, analyze / refactor from XML Schema / JSON. Oracle is a proud enterprise sponsor; with NIEM.gov support. Do SQL data import/map+ Open Data API delivery+ Hibernate JPA + UI Forms/Pencil Makes XSD schema (default, flatten, NIEM... -
7
xplordb
Open mineral exploration database system
Now also living on gitlab. https://gitlab.com/mds-/xplordb Mineral Exploration Database template/ system for Postgres/PostGIS and QGIS. The project incorporates import scripts, data storage, validation, reporting, 3D drill trace generation and more. psql, pgAdmin and QGIS are the suggested database and GIS front-end programs. -
8
openLCA
professional open source software for LCA
Software for sustainability assessment, highly modular; initially focused on Life Cycle Assessments. -
9
pyDaSSQLiteMan
An easy way to manage SQLite databases and query CSV files
Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ . I'd recommend something after version 3. Testing has been Windows based. SQLite is a free database... -
The #1 Embedded Analytics Solution for SaaS Teams.Qrvey’s comprehensive embedded analytics software enables you to design more customizable analytics experiences for your end users.
-
10
QAL
Query Abstraction Layer
Project has moved to: https://github.com/OptimalBPM/qal QAL is a collection of libraries for mining, transforming and writing data from and to a number of places. Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages. It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming. It uses XML/JSON formats(self-generated SQL schemas... -
11
Ava: Testdata Xsl
generates Testdata on base of excel: creates xml,excel,csv,html,sql,+
this tool for test-data-generation receives an 'excel-sheet' as primary input. second important paramter is the 'number of test-records to produce'. The excel-data will be reused as long data is needed. This tool is hightly paramatrisazable by the use of 'xsl scripts'. data can be created, updated, modified and finally exported in a format of your choice Main Fuctions: (1) Generates Testdata (excel, xsl, xml) (2) Exports generated testdata in multiple formats (csv, excel, html, sql-insert... -
12
FNN Parser
Programm zum Konvertieren des FNN XML Formats in CSV Format
Das Programm ist als Hilfe für die Energieversorger erstellt worden, zum konvertieren des FNN -Lieferscheins in ein CSV Format. Das Projekt kann als Vorlage für den Internen Daten-Import genutzt werden. -
13
Yascade
Yascade prepares documents to be formatted
Yascade uses Excel to build document projects. Add your info into Excel without formatting and press a hotkey and Yascade builds your project into a formatted document or series of numbered documents. Overview (20min): http://www.youtube.com/watch?v=IDq53MknLRg Tutorial #1 (45min): http://www.youtube.com/watch?v=mqqqs0F9F3Q Tutorial #2 (2hrs): http://www.youtube.com/watch?v=w7HXVo9IL40 Visit us on Reddit: http://www.reddit.com/r/Yascade Hotkey to open or create a new document on your... -
14
Toolsverse ETL Framework
Open source Extract Transform Load engine written in Java
ETL Framework is a standalone Extract Transform Load engine written in Java. It includes executables for all major platforms and can be easily integrated into other applications. Key Features: * embeddable, open source and free * fast and scalable * uses target database features to do transformations and loads * manual and automatic data mapping * data streaming * bulk data loads * data quality features using SQL, JavaScript? and regex * data transformations Requirements * Java... -
15
Set of classes for PHP that allow Excel XML files to be generated dynamically. Nearly a full implementation of the MS XML architecture. Requires PHP 5+ Does not require any XML libraries
-
16
XLSQLATOR
A tool to convert Excel sheets into SQL code
Build a tool with nice GUI as well as powerful options to automate building SQL DDL and import statements from an Excel Sheet / Workbook. -
17
dbUPLoader is a tool to import data from csv or MS-Excel files into a database. You can distribute data across several tables, create relationships between imported data and integrate sub queries to reference existing data.
-
18
This script takes the Western Australian linked health data provided by the Data Linkage Unit and converts it to a TAB delimited format that is easier to import into SPSS or Excel etc. Mileage may vary.
-
19
Serialization + persistance : in a few lines of code, compress and annotate Python objects into SQLite; then later retrieve them chronologically by keywords without any SQL. Most useful "standard" module for a database to store schema-less data.
-
20
This is a social genealogy web application, compatible with GEDCOM Files (import/export). Aim is to to agregate genealogy informations from any people and to allow mashups over the web.
-
21
dot net tool to convert from csv, or excel to wiki table format. Useful to import your data in wiki.
-
22
All2SQL is a PHP library that converts any parsable format to valid SQL insertion code, allowing you to import any data source into your database. All you need is a parser! The MySQL platform is supported, with more to be added.
-
23
QExcel Converter SQL QT4, Import xml excel/openoffice 2003 format, sqlite3 sql text/binary, edit table and export to various Format, Pdf XSL format objects Apache fop JAVA(XSL-FO), XML/XSLT , excel, SQL text sqlite3 dump file and MYSQL SQL to XML/XSL.
-
24
Add-On functionality for the Apache Torque Project (http://db.apache.org/toque). This project provided user contributed add-ons that are not part of the Torque distribution, such as an XML import/export framework, custom templates, and the like.
-
25
A Program designed to read a commonly flat-file format and produce SQL to try and infer a relational database scheme from the information provided. Then creates SQL to create necessary tables and import file data.
- Previous
- You're on page 1
- Next