topleft
topright
SQLPlex forums
Welcome, Guest
Please Login or Register.    Lost Password?
SQLPlex forums Mentat Technologies IDE's DreamCoder for MySQL
how can import a excel document to mysql table (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: how can import a excel document to mysql table
#68
mail-question (User)
Junior Boarder
Posts: 29
graph
User Offline Click here to see the profile of this user
how can import a excel document to mysql table 5 Months, 2 Weeks ago Karma: 0  
I have Dreamcoder for MySQL 4.4 build (4.4.1.5). I can’t import data into tables from my PC. Is this because I need a higher version to be able to do so?

Question : Clay
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#69
ptesone (Admin)
Admin
Posts: 29
graph
User Offline Click here to see the profile of this user
Re:how can import a excel document to mysql table 5 Months, 2 Weeks ago Karma: 0  
mail-question wrote:
QUOTE:
I have Dreamcoder for MySQL 4.4 build (4.4.1.5). I can’t import data into tables from my PC. Is this because I need a higher version to be able to do so?

Question : Clay

DreamCoder for MySQL has many export and import options, but this option is available only in the commercial versions, please check the matrix comparison:

http://www.sqldeveloper.net/mysql-manager-developer/dreamcoder-for-mysql-matrix-comparison.html

The import process is very easy, please follow the next steeps:

1. Open the table.
2. Click in the button Import data.
3. Choose MS Excel.
4. Load the file
5. Create the link into database field and excel document.
6. Import the data.

The process is very similar for CSV file or TEXT file.
Import Wizard.


Regards,
Peter Tesone
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
get the latest posts directly to your desktop
 
SQLPlex | Copyright © 2008 Mentat Technologies. All Rights Reserved