N:\IMAGES\646_660\646\002637;290362142;\26\1\0001.tif the above line is a sample of the text file that i need to be linked to. i need to have my linked table to make delimters at "\" and at ";" is there a way of doing this?
Will using the Replace() function twice work for you? Allen Blevins wrote: >N:\IMAGES\646_660\646\002637;290362142;\26\1\0001.tif > >the above line is a sample of the text file that i need to be linked to. i >need to have my linked table to make delimters at "\" and at ";" > >is there a way of doing this? -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200808/1
