|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
July 10th, 2003, 11:29 AM
|
|||
|
|||
|
Query to MySQL by VBA
I have this strange question, I wanna pass a query to a MySQL Db from Vb
Now I am riting this query as: str = "load data infile 'c:/trial.csv' into table trial fields terminated by ',' enclosed by '" ' " but there is an error in the last part... Can ne one help me out with this? Thanx n regards. A
|
|
#2
July 10th, 2003, 09:31 PM
|
|||
|
|||
|
Can you post the error message? Are you fields enclose by a single tick or a double quote?
|
|
#3
July 11th, 2003, 07:47 AM
|
|||
|
|||
|
Hey thanx, I got hold of the problem yest evening. actually had to give a " between two 's so...the second part was not being detected. Got around by giving an ANSII character in place of that.
Neways, thanx again for your help. A
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Query to MySQL by VBA |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
