Online Documentation for Data Import for SQL Server

EMS Data Import FAQ


Please read this page attentively if you have questions about Data Import for SQL Server.

 

Table of contents

 

 

Question/answer list

 

Q: What is EMS Data Import for SQL Server?

A: EMS Data Import for SQL Server is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, TXT, CSV, XML, MS Excel 2007, MS Word 2007, HTML, ODF files to SQL Server tables. It provides adjustable import parameters, including source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc. Data Import includes a wizard which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.

 

 

Q: What do I need to start working with EMS Data Import for SQL Server?

A: First of all, you must have a possibility to connect to some local or remote SQL Server to work with Data Import. You can download SQL Server from http://www.microsoft.com/downloads/. Besides, you need your workstation to satisfy the system requirements for Data Import for SQL Server.

 

 

Q: What is the difference between the Import feature of SQL Manager for SQL Server and the Data Import for SQL Server utility?

A: First of all, Data Import for SQL Server works faster as it is a considerably lighter application. Besides, it provides additional features for query building, namely:

  • import data to several tables simultaneously;
  • import data to tables selected from different databases;
  • the command-line version of the utility to import data using the configuration (template) file with all import settings;
  • automatically creates table structure.

 

 

Q: Are there any limitations implied in the trial version as compared with the full one?

A: Actually the trial version of the utility only allows you to import 20% of records into each table. With this limitation, you can test all the features implemented in Data Import for SQL Server within the 30-day trial period.

 

 Note: There is a 100 records (instead of 20%) limitation when importing from CSV, TXT or MS Access files.

 

 

Q: What is the easiest way to configure the template files for the Data Import console application?

A: You can configure the template files for each table visually using the Data Import Wizard application. Set the required options and select the Tools | Save Template menu item. All the options will be saved to the template file which can be used by the console application.

 

 

Q: I work behind a firewall (router). Can EMS Data Import connect to a remote SQL Server server?

A: Yes, but to do this, you should open the port where SQL Server works (1433 by default) on your firewall and on the firewall of the remote network.

 

 

Q:How to connect to a named instance of SQL Server in EMS Data Import for SQL Server?

A:To connect to a named instance of SQL Server 2005 just enter instance name in after host name and back slash symbol in 'Host name' field at the Setting Connection Properties step. (For example: my_server\my_instance.)

To connect to a named instance of SQL Server 2000 you need:

- Run SQL Server Client Network Utility (WINDOWS\\SYSTEM32\\cliconfig.exe) on client computer where Data Import for SQL Server runs.

- Go to the second (Alias) tab of the Utility.

- Add a new server alias with Server Name in form <server_name>\\<instanse_name> and TCP/IP as Network library.

- Use the server alias name as host name in Data Import.

 

 

Q: When connecting to SQL Server I get an error "SQL Server does not exist or access denied". What is wrong?

A: Probably, your SQL Server is installed as a named instance (See Q. "How to connect to a named instance of SQL Server in EMS SQL Manager for SQL Server?").

Besides, the following factors can be the reasons for connection problems:

- You are trying to connect to SQL Server beyond your local network, through firewall (See Q. "I work behind a firewall (router). Can Data Import connect to a remote SQL Server?"

- Wrong login/password. Either you use SQL Server Authentication, but this authentication type is forbidden on the server, or you use Windows Authentication to connect to the server, but the login that corresponds to your domain name is absent on SQL Server.

- MDAC works incorrectly. Try to reinstall Microsoft Data Access Components.

- SQL Server works on a non-standard (other than 1433) port (See Q. "I can access my server via an alternative port. I have searched for a setting in the program to alter the connection port, but have not yet been able to locate this. How would I go about altering this port?".

- There are no enabled client connection protocols. Or all enabled client connection protocols are disabled on server side. Use SQL Server Client Network Utility (WINDOWS\\SYSTEM32\\cliconfig.exe) for connection to SQL Server 2000 or lower or SQL Server Configuration Manager to enable appropriate protocols.

 

 

Q: I can access my server via an alternative port. I have searched for a setting in EMS Data Import for SQL Server to alter the connection port, but have not yet been able to locate this. How would I go about altering this port?

A: To connect to SQL Server 2005 on alternative port do the following:

- Run SQL Server Configuration Manager on client computer where Data Import runs.

- Expand the SQL Native Client Configuration section.

- Select the Aliases section.

- Add a new server alias and set server name, port number and TCP/IP as Network library.

- Use the server alias name as host name in Data Import utility.

To connect to SQL Server 2000 on alternative port do the following:

- Run SQL Server Client Network Utility (WINDOWS\\SYSTEM32\\cliconfg.exe) on client computer where Data Import runs utility.

- Go to the second (Alias) tab of the Utility.

- Add a new server alias and set server name, port number and TCP/IP as Network library.

- Use the server alias name as host name in Data Import utility.

 

Scroll to top

 

If you still have any questions, contact us at Support Center.