Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    178

    Unanswered: importing from excell

    i want to import from excell but one of the columns has a 36 diget number in it that i want to split the number up the first i want to put into a new field the last six digets i dont want but the six digets before that i want into a new field can any1 help with this thanks

  2. #2
    Join Date
    Mar 2006
    Posts
    163
    Why not just import as is and then do an update query?

  3. #3
    Join Date
    Aug 2004
    Posts
    178
    thats all very well but how do i ask the query to pick the digets i want

  4. #4
    Join Date
    Mar 2006
    Posts
    163
    Use the Left function.

    Only6:Left([YourField], 6)

Posting Permissions

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