Home > XlsToSql, Excel To Sql Server > XlsToSql FAQ

XlsToSql - Excel To Sql Server »

XlsToSql FAQ

If you have any question, contact us:

FAQs


1. How to skip columns ?

In import form, click "Select Columns" button.

Import Data From Excel To Sql Server - select import excel columns

In "Select Columns" dialog, uncheck the box for the columns that you want to skip, click "OK" button.

Import Data From Excel To Sql Server - skip excel columns

2. Logon error: "SQL Server does not exist or access denied" or "Specified SQL Server not found"

If you are using Windows 2000, you need install MDAC version 2.8 from:

http://msdn2.microsoft.com/en-us/data/aa937730.aspx

or

http://www.download.com/3001-2404_4-10281285.html?spi=9c0ff79b64718e43ae4d795ed3dbd826&idl=n

see also: Specified SQL Server not found .

3. Logon error: "ConnectionOpen (Invalid Instance())"

On Logon form, "Server" should be "host,port" like "PAN,1433" , or "ip,port" like "192.168.0.2,1433".

see also: Logon to Sql Server .

Download

30-day free trial
Download XlsToSql

Requires Windows 2000, XP, 2003, Vista.
128MB RAM,
Pentium 3.

Price Info

$59.95 or less

Buy XlsToSql

30-day money back guarantee