Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Ontario, Canada
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text to Columns (Access 2003)

    Hey there

    Is there a feature in Access similar to Excel's Text to Column feature, where you can separate data in a column?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text to Columns (Access 2003)

    File > Get External Data > Link Tables allows you to link to text files, and specify whether the text file is comma-separated or fixed-width. That's the closest thing that I'm aware of.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Text to Columns (Access 2003)

    Text to column will split data (currently in one field), into two separate fields.

    Access does not have anything as simple as the text to column feature.

    You can do it using action queries,the InStr function, and the Left and Right functions.

    <post#=376328>post 376328</post#> gives more info with some examples.
    Regards
    John



  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text to Columns (Access 2003)

    If the table is small you migth want to export the key and the column you want to split to Excel. Once there split your data and then add any new columns you need to hold the split off data. Attach the Excel spread sheet to your database and then do an update query to your original table.
    (Be sure to back up your original table first.)
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

Posting Permissions

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