ExportTxt2msSQL

Uses the Microsoft DTS (Data Transformation Services) Engine to export each line a text file (or a set of text files) as a row in a table in a Microsoft SQL Server (2000/2005) database.
Can filter for a folder, list of folders, exclusion list for files, selected file extensions.
Configuration kept in an XML file.

Features

Export lines in a text file to Microsoft SQL Server.
Choose file/folder/subfolders, with exclusion list and file extension types list to process
Useful for code lines analysis for any notepad-readable code files such as FRM, BAS, CLS, VBP and also TXT files.
Unattended run configurable with parameters in a config XML file.

Project Samples

Project Activity

See All Activity >

License

Creative Commons Attribution License

Follow ExportTxt2msSQL

ExportTxt2msSQL Web Site

Other Useful Business Software

Gen AI apps are built with MongoDB Atlas

Build gen AI apps with an all-in-one modern database: MongoDB Atlas

MongoDB Atlas provides built-in vector search and a flexible document model so developers can build, scale, and run gen AI apps without stitching together multiple databases. From LLM integration to semantic search, Atlas simplifies your AI architecture—and it’s free to get started.

Start Free

Rate This Project

User Reviews

Be the first to post a review of ExportTxt2msSQL!

Additional Project Details

Operating Systems

Windows, Windows Server

Intended Audience

Developers, System Administrators

User Interface

Command-line, Win32 (MS Windows)

Programming Language

Visual Basic

Database Environment

Microsoft SQL Server

Related Categories

Visual Basic Documentation Software, Visual Basic Source Code Analysis Tool, Visual Basic Code Review Software

Registered

2013-07-19

Similar Business Software

WildEdit

If you ever need to make the same changes to many files at once, then WildEdit will save you a lot of time. It is an interactive tool for users to edit a set of plain text files in a folder hierarchy, filtered by wildcards. This makes it ideal for editing web pages and software source code or...

See Software
SSIS

SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL...

See Software
XiMpLe

A simple editor for XML and JSON files based on a grid table view with some unique functionalities. User doesn't need to care about xml or json rules. It's possible to compare and merge xml files in a grid view. There is a support for validating xml with XSD schema(s). It can be used also...

See Software
xlrd

xlrd is a library for developers to extract data from Microsoft Excel (tm) .xls spreadsheet files. xlrd is a library for reading data and formatting information from Excel files in the historical .xls format. This library will no longer read anything other than .xls files. Ignores charts,...

See Software
PDFix SDK

PDFix SDK provides the power to make existing PDF files accessible automatically. It helps you convert PDF files to high-quality accessible PDF/UA . Our auto-tag feature recognizes all important structures in your documents like texts, images, tables, headers/footers, headings, lists, and...

See Software
EditRocket

EditRocket is a comprehensive text and source code editor, offering a suite of XML editing tools designed to enhance productivity and ease of use. Its XML Validator allows users to check the syntax of XML files and validate them against schemas when the "check schema" option is selected. The...

See Software