loop through access table rows vb.net
Posted on 2012-03-19
I have a table in a access db it has several fields, but i am only interested in 2.
the first field is uniquekey, this represents the db uniquekey of each track
the second field is filename
which is basically the full path to where the track is stored,
i.e. Filename D:\Tracks\fff250bd-6c12-4f11-ab9e-a84568a74afb\1cd6e11e-b89e-4899-9aea-31f01401b18c.mp3
I need to copy and rename the files to another folder from all the rows in the table renaming the mp3 files to the uniquekey.
the database name is library
the table is csv
Could anybody please give me some code to achieve this in vb.net