I have a requirement to load text files in to access db.Fo example i have 10 test files saved in c://Input file names format is 123_File1.txt etc. The table contains two columns (Id,data).I want to strip the filename and insert the first 3 letters of the file name in to the column id and also to store the text file in to data coulmn.My text files contains xml date in it.
How can we implement this logic in java?
Thanks in advance