i have the following code for loading the csv file in to database dynamically.
that is i want to give the file path dynamically .


Dim conn As New MySqlConnection
Dim myCommand As New...

thanks hoppy for ur advice..


i m trying to use the following code..........but it is giving some errors and moreover i just want to extract column no 4 and 6........how can i do this with this...

yeh its a csv file.
i heve attached it with this thread

can anyone provide me with the script for extracting columns from a text file.
the script needs to be in visual basic

can u help me out with any of these methods?

i have two data files which contain the values to be stored into the columns of the table .
these files are of same nature ,i.e their data needs to be put into the same table.
these files have data...

i have to load the two files into the same table not in two different tables.
then i want to compare the following thing
say c1 is column1,c2 is column 2
r1 is row1 and r2 is row2
now the values...

i have done all those changes.
now it is giving the following error

Parameter '?f''' must be defined.

i have load two data files into a mysql table.now i want the compare the data from these two files (i.e want to compare a particular column of the table and want to get the difference between the...

everytime it is not able to find the correct path,infact it shows this error

File 'C:\Program Files\MySQL\MySQL Server 4.1\Data\systemconfiguration\?f' not found (Errcode: 22)



but when i...

this is what i want to do dynamically with the help of parameters.
what i want is that user just enter the filename along with the path in the textbox and then the code automatically put the data of...

no path is not fixed and files are in txt.

i want to load bulk data files dynamically inot mysql database by using visual basic as front end.
i want to get the filepaths dynamically i.e i just enter the file name into textbox and it will...