+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, create import csv in Technical; Hi, I used to have an access query which changed the SIMS year list extract into a form which I ...
  1. #1
    KWestos's Avatar
    Join Date
    Jan 2008
    Posts
    520
    Thank Post
    91
    Thanked 54 Times in 45 Posts
    Rep Power
    26

    create import csv

    Hi, I used to have an access query which changed the SIMS year list extract into a form which I could upload into active directory. I need an access query which will do the following

    currently the export looks like "John Smith"

    What I want is the field to look like "09SmithJ"

    I know this is simple, but it's bugging me.

    Many thanks

  2. #2

    Join Date
    Oct 2008
    Location
    Somewhere in the north
    Posts
    351
    Thank Post
    11
    Thanked 14 Times in 12 Posts
    Rep Power
    15
    I've not touched Access in *years*, but the following in Excel would do it if you had 'John' in A1 and 'Smith' in B1, stick this in C1

    = "09" & B1 & LEFT(A1,1)

  3. Thanks to grumpy_git from:

    KWestos (3rd September 2009)



SHARE:
+ Post New Thread

Similar Threads

  1. Create bulk ad groups from a csv file
    By ful56_uk in forum Windows
    Replies: 2
    Last Post: 20th July 2009, 06:06 PM
  2. (Bulk) Change user passwords using csv
    By PEO in forum Windows Server 2008
    Replies: 2
    Last Post: 3rd June 2009, 01:50 PM
  3. Save CSV to Server (serialize?)
    By danIT in forum Coding
    Replies: 3
    Last Post: 21st May 2009, 09:34 AM
  4. MOSS2007 - SProfile and Import Settings - import profiles has hung
    By damienharrison in forum Web Development
    Replies: 5
    Last Post: 3rd February 2009, 12:40 PM
  5. Import Staff into Sims.net via a CSV
    By stephen.loader in forum MIS Systems
    Replies: 2
    Last Post: 14th January 2008, 12:32 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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