|
Replies:
2
-
Pages:
1
-
Last Post:
Nov 1, 2012 2:13 AM
by: Kronborg
|
|
|
Posts:
35
Registered:
10/16/12
|
|
|
|
Paste from Excel into Toad?
Posted:
Oct 18, 2012 6:49 AM
|
|
|
Navicat and even the old MySQL Browsers allow us to copy a range in Excel and paste it directly into a table (at the bottom). I understand that you can't do this with an Oracle db, but clearly you can in MySQL.
Would love to be able to do this in Toad!
|
|
|
Posts:
1
Registered:
10/19/12
|
|
|
|
Re: Paste from Excel into Toad?
Posted:
Oct 19, 2012 8:09 AM
in response to: aoeusnth
|
|
|
I have a similar 'need'.
Is there a way in Toad to import a spreadsheet from xls and generate the tables and fill the data?
:O)
|
|
|
Posts:
1
Registered:
11/1/12
|
|
|
|
Re: Paste from Excel into Toad?
Posted:
Nov 1, 2012 2:13 AM
in response to: The Harlequin
|
|
|
In mySQL for SQL-server there is a import options under Tools - Import - Import Wizard. You can import CSV-files and Excel-files.
Dont know if this is in the MySQL edition too.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
