| |||||
XlsToSql is a useful piece of software that allows you to import Excel data to SQL Server. "Server" is your Sql Server hostname or ip address. If you can not connect to remote database, try "host,port", like: "PAN,1433", or "ip,port", like: "192.168.0.2,1433".
"Database" is your Sql server database name, usually is "master". Authentication, you can use "Windows Authentication" or "SQL Server Authentication". User Name and Password are your Sql Server system username and password.
Here are some key features of "XlsToSql":
· Read data from excel sheet into an Sql Server table
· Run SQL command to see importing results
· Support Unicode
· Support text, ntext, image type
Requirements:
· Processor: Pentium 133 or better
· RAM : 32M RAM or more
· Excel is required
Limitations:
· Can only import up to 1000 records
· 30 days trial period
· Nag screen
What's New in This Release: [ read full changelog ]
· Add "Make Batch File".
· Add "Date Format Config".
· Some other bug fixes and enhancements.

Via: XlsToSql 2.2 Release 1 Build 64