Insert Data to MySQL table

[jeyanthi]

Hi.Need help. I already created the tables and column fields in MySQL. Now i have a 1D Array which contain similar field in the MySQL table. Example DR1in the array is similar wit DR1 column name in the SQL table.

I have another array which contains the data for the column.

help me cos there is an error wit the coding.

[MikeS81]

Hi jeyanthi,

can you upload your vi and maybe your txt file? Where do you get the error?

Mike

[jeyanthi]

the attachment of vi and text file

[MikeS81]

Hi jeyanthi,

you get the error because you connect a txt file to the database open function. You can only connect udl or dsn.
See the attachment please, it makes the same as your vi.

Hope it helps.

Mike

[jeyanthi]

thk u :womanhappy:

[Mathan]

Mike,

What is udl and dsn?

Mathan

[smercurio_fc]

http://en.wikipedia.org/wiki/Universal_Data_Link#Universal_data_link

http://en.wikipedia.org/wiki/Database_Source_Name