|
Replies:
1
-
Pages:
1
-
Last Post:
Aug 4, 2010 2:59 PM
by: MichelB
|
Threads:
[
Previous
|
Next
]
|
|
|
|
|
|
CSV import issues
Posted:
Aug 3, 2010 9:16 AM
|
|
|
Hi,
I am trying to import CSV data containing chunks of text. I find CSV import easily confused when text contains ' or " or a mix of them. It seems like Toad does not escape those things correctly when forming SQL.
The CSV file is valid and properly escaped. It can be opened in Excel just fine.
I tried both 4.6 and 5.0 beta with the same results.
Is that a known issue?
Thanks,
Dima.
|
|
|
Posts:
4
Registered:
8/4/10
|
|
|
|
Re: CSV import issues
Posted:
Aug 4, 2010 2:58 PM
in response to: dima_rogozin
|
|
|
If you are running MySQL on a Windows machine you could try the "mysqlimport.exe" command.
You can start this also from Toad, but is more robust than the Toad import tool.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
