Excel-MySQL Frequently Asked Questions:
The following are the most frequent issues that you might need to ask about. If you have any other
inquiries or suggestions regarding Excel-MySQl Converter, Please contact our
support team.
Q: Are there any constraints on number of fields or number of records in the
conversion process? I have some fairly large tables.
A: There are no limitations regarding the number of fields or number of records.
Q: I have previously created a scheduled task that
runs every certain period of time. How can I disable, delete or edit this task?
A: Just open the windows
control panel, select
Scheduled Tasks
item. Then double click on the task you want to edit. This will open the task
properties window
where
you can change the task settings.
Q: I am using windows 2000/XP, The task is created
successfully but it doesn't run?
A: You probably forgot to supply you windows user name and password. In
case of windows XP or windows 2000 the windows task scheduler will not run the
task unless you supply a user name and password (Windows account) in the task
properties window.
Q: I'm trying to convert a (local) Excel file to a (remote) MySQL database.
What value (and its format) should I put in the "Host" field when connect to
MySQL? Do I need to change the port number?
A: For a remote connection to MySQL server you should consider the following:
- First, You should make sure that the remote server you are trying to connect to
allows remote connections, Some server disable remote connections for some
security reasons.
- If your server allows remote connections, you should ask for the exact
connection info: Server name, user name, password and the used port number.
- You should also make sure that you have enough privileges to Create/Drop tables
or databases as required by the conversion process.
If you have any other questions, please contact our support team at:
support@SoftGalaxy.net