Results 1 to 2 of 2

Thread: Changing Text file to Access/Excel/Word Format

  1. #1

    Thread Starter
    Member KHAWAR's Avatar
    Join Date
    Dec 2003
    Location
    SYDNEY
    Posts
    52

    Changing Text file to Access/Excel/Word Format

    I have a problem. Can you convert the file to only a list in Access/Excel/Word

    now the format is like this

    anchovy images\a\a00.gif1261.gif ancient images\a\a00.gif1262.gif anciently images\a\a00.gif1263.gif ancillary images\a\a00.gif1264.gif and images\a\a00.gif1265.gif anecdotal images\a\a00.gif1266.gif



    and i want it like this:-

    anchovy images\a\a00.gif1261.gif
    ancient images\a\a00.gif1262.gif
    anciently images\a\a00.gif1263.gif
    ancillary images\a\a00.gif1264.gif
    and images\a\a00.gif1265.gif
    anecdotal images\a\a00.gif1266.gif

    Please send me a code or any way you can tell me

    Thanks
    Attached Files Attached Files

  2. #2
    Fanatic Member doofusboy's Avatar
    Join Date
    Apr 2003
    Posts
    526
    Just read in the existing file, insert a vbCRLF after every second space you find, and write it out to a new file
    Do canibals not eat clowns because they taste funny?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width