Jimbo1954
asked on
loop through access table rows vb.net
Hi guys
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
ie: 3402
5601
6507
the second field is filename
which is basically the full path to where the track is stored,
i.e. Filename D:\Tracks\fff250bd-6c12-4f 11-ab9e-a8 4568a74afb \1cd6e11e- b89e-4899- 9aea-31f01 401b18c.mp 3
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
Best regards
Jimbo
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
ie: 3402
5601
6507
the second field is filename
which is basically the full path to where the track is stored,
i.e. Filename D:\Tracks\fff250bd-6c12-4f
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
Best regards
Jimbo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER