资 源 简 介
|Current Status | Beta|
|:--------------|:----|
|Build |1.0.3710.27340|
|Updated | 27/02/2010|
This is a Winforms utility for converting text data, separated by tabs, into sql statements. It acts primarily as a quick way of importing small simple datatables into SQL Server without using the Import Data Wizard which in SQL Server 2000 & 2005 is fairly terrible and seems to fallover a lot.
The basic usage of this utility is as follows :
User has Excel spreadsheet of x columns and y rows. User wishes to get this into a SQL table.
User loads tab2sql.
User copies and pastes the data from Excel into the upper text box within tab2sql main form.
User presses "tab2sql" button. This should populate the lower text box with a set of SQL statements.
User copies and pastes the resulting text into SQL Server Management Studio / WinSQL / Query Analyzer / SQL Anywhere iSQL and runs it.
