If it's a one off file/table, then export it as fixed width, then re-import it using '|' as your field delimiter.
If it's only one field in a table that this relates to and you're going to be using VBA to split up the row then it's a bit more complicated, but I can post an example if you need it. Owen --- In [email protected], verly yuli <[EMAIL PROTECTED]> wrote: > hello all > > i have a example text > abcde|ajhiu|reiek > how to split this text to row? > > thank you for all support > > regards warmest > > > verly yuli > > > > ____________________________________________________ > Sell on Yahoo! Auctions no fees. Bid on great items. > http://auctions.yahoo.com/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
