Frequently Asked Questions
1) Can I load data
into MySQL database hosted in Shared Web Hosting?
2) Can I run jobs from command line OR, Can I run transfer jobs from other applications?
3) Can I use Data Loader to load data from Oracle or MySQL which is installed on Unix Machine to any other Database?
4) Can I convert Delimited Text File to another Delimited Text, Fixed Length format and Vice Versa?
5) Can I use Data Loader to Load data from one Oracle Ver. to Another Oracle Version?
6) Is there any limit on number of rows which data loader can load?
7) Can I use WHERE Condition for filtering rows?
8) What other components are required to run Data Loader?
9) How do I check whether MDAC is installed or not?
10) How do I remove the restriction of 50 Rows?
11) Does Data Loader runs Conversion jobs at schedule date and time?
12) Which Databases are supported in the new version of Data Loader?
13) Can I do transformation in Data Loader?
14) Can I load from multiple Text or CSV Files simultaneously?
15) Can I specify WHERE condition while loading data from delimited text files?
16. Connection problem while connecting to MySQL Databases.
17. I am getting "Too many fields defined" error after selecting Excel Worksheet.
18. No tables defined error while opening Excel Worksheet.
19. Some columns values are null after converting an Excel worksheet into any of the supported database?
20) Which Operating System is required to run Data Loader Ver. 3.6 or 4.x ?
21) Why is loading process slowly when I choose UPSERT or INSERT feature.
22) Does it supports Windows-64 Bit or 64-Bit databases?
Ans. Yes! you can use Data Loader to easily load data from any database to MySQL database hosted in Shared Web Host. To do this you have to first logon to CPanel and then add your IP address to access the database as shown below
(CPanel/MySQL Databases Screenshot)
To find out your IP you can go to the following site whatismyip.com.
Once you have added your IP now start Data Loader and type your domain name (for ex. dbload.com) and user account and password and click connect.
Ans. Yes, you can run saved sessions by issuing a operating system command. You can call Data Loader runtime by supplying the following arguments
DLRUN.exe <session_id> [showoutput]
<session_id> : The session ID which you want to execute.
showoutput : (Optional) If specified then Data Loader will show a output window
For example you have saved a session by ID 15. Now, to run this session issue the command as follows
Files\Data Loader Standard Edition\DLRun.exe 15 showoutput
(Please replace C:\Program Files\Data Loader Standard Edition with the directory path where you have installed Data Loader)
Ans. Yes, you can load data from Oracle or MySQL which is installed on another O/s. For this you must have proper Client Software installed on the machine where you are running Data Loader.
Ans. Yes, you can use Data Loader to Convert Delimited Text files to another Delimited Text File or Fixed Length. You can even filter columns and Specify WHERE conditions while converting.
Ans. Yes, you can use Data Loader to load data from one Oracle version to another Oracle Version.
Ans. No, Data loader can be used to load millions of rows. Our many existing customers are doing that. The Trail version is limited to load not more than 50 Rows. But if you purchase a registered version of Data Loader this restriction will be removed
Ans. Yes, you can filter rows while loading from MySQL, Oracle, MS-Access, MS-SQL Server Foxpro Database source to any other Target Database or Text file.
Ans. You should have Microsoft Data Access Components (MDAC) Ver. 2.0 or later installed in your system. From Windows 2000 onwards this component is automatically installed when you installed windows 2000. If you are running Windows 98 or 95 then please first install MDAC before running Data Loader. You can download MDAC from Microsoft website
Ans. First go to control panel/Administrative Tools if you see the ODBC Manager. Then MDAC is installed otherwise not.
Ans. This happens if you are running Trial Version of Data Loader. If you want to remove this restriction please purchase a registered version of Data Loader.
Ans. Yes, Data Loader Ver 2.0 comes with its own Scheduler. Just create a session specify the schedule time and DL will executes the conversion jobs periodically at specified times.
Ans. Currently Data Loaders Support loading to and fro from MS-SQL Server, MySQL, Oracle, MS-Access, FoxPro, Text format.
Ans. Yes by using views. For example: suppose you want to load columns from multiple tables which are joined on some field to another Database. To achieve this first create a joined view in your Oracle or MS-SQL Server Database and then start Data Loader and select this view in the source and load it into any of the databases.
Ans. Yes, from Data Loader Ver. 2.5 you can load from multiple text files simultaneously. Even if you have different delimited files in one folder you can select these files and load it into any of the supported database.
Ans. Yes, from Data Loader Ver. 2.5 you can specify WHERE condition to filter rows while loading from Delimited Text Files to any other supported Databases.
Ans. This usually happens because of Firewall. If you have a firewall install then firewall software will not allow Data Loader to connect to MySQL Server. To avoid this please allow Data Loader to access your computer by modifying firewall settings. If Firewall settings are OK and still you are not able to connect MySQL database then, please make sure you have MySQL ODBC Driver Ver. 3.51 installed in your system. If you don't have MySQL ODBC 3.51 Driver, you can download the same by clicking here.
Ans. This happens if you select a worksheet or range which contains more than 255 columns. Microsoft Excel driver supports only 255 columns, that's why you will not be able to transfer more than 255 columns per sheet. Even if the worksheet seems to contain fewer than 255 columns, please make sure that the columns in the worksheet that seem empty aren't filled with " " or non-print chars.
Ans. This error occurs if the Excel worksheet does not contain proper ranges or MS Excel driver or provider is not able to correctly interpret the rows and columns in the worksheet. This can avoided by defining ranges in the worksheet.
To Define a Named RangeTo define a named range in Microsoft Excel, follow these steps:
- In your Microsoft Excel worksheet, select the rows and columns that contain the information that you want to import.
- On the Insert menu, point to Name, and then click Define.
- In the Names In Workbook box, type a name (the name may not contain spaces nor should it be the same as one of the column header names) for the range that you specified, and then click Add.
- Click OK, and on the File menu, click Save.
- Save and quit the workbook.
Ans. This happens if the Excel Column contains intermixed data. If
you have numeric values mixed with text values in the same column. Both
the Jet and the ODBC Provider return the data of the majority type, but
return NULL (empty) values for the minority data type. This is a known
bug in the Microsoft Excel ODBC driver and OLE DB Provider.
There is a simple solution for this.
When this value is set to zero, Microsoft Excel will scan all records in your table to determine the type of data in each column.
After setting the registry value please transfer the data again from Excel to any other database.
Ans. All windows platforms are supported including Windows 7 and Windows Vista
Ans. Please make sure that the target table is having a primary key index created on the matching column. If no index exist then the processing will become slow because Data Loader has to compare each and every record for existence.
If you have any other questions or problems please contact us and we will be glad to help you.
For Technical Support: email@example.com
For General Support: firstname.lastname@example.org
Ans. Yes Data Loader will run on Windows 64 bit operating systems and it can also connect to 64 bit databases but, you need to install 32 bit OLE DB Provider or 32 bit ODBC driver to access 64 bit databases.
|Our Esteem Customers|
|* CapsGemini, India
* Quantum Corp, USA
* Dept. of Defense, Australia
* Lawrence Livermore
* National Laboratory, California
* ViableCom, Canada
* Results Radio
* True oil llc
* Siemens ITS
And many more…
|I really like the
simplicity of Data Loader.... Kirsten
Data Loader is making my transfer job from Oracle to Text files very easy and fast. Previously I have to use lot of SQL commands to achieve this. Thanks to Data Loader....Ronald
|Try Forms Data Loader to Load Data through Front End Forms using Macros. Download Free Trial Version Now|