Results 1 to 2 of 2
  1. #1
    ptworthing is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Posts
    1

    Ensuring daa import software version numbers as numbers not dates

    Hi, I have recently upgraded to Access to 2007 and have found that when I import a large dataset in the forma of a unicode txt file, access format my data - for example it converts a field that contains the version number of a software to a date. For example 2.12.0 into 02/12/2000. This didn't happen on 2003. WHat is the eaasiest way of fixing this ?



    Regards
    Phil

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,439
    I don't have acc2007, but I would look to the import wizard, Go to the advanced section and see if there is a way to create a specifications file ( you can also set other properties there). I would set the version number of a software to a text datatype.

    This existed in 2003 - perhaps you have used it previously.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query with Dates as Numbers
    By forrestapi in forum Queries
    Replies: 9
    Last Post: 04-05-2011, 08:46 AM
  2. Adding numbers to dates
    By MFS in forum Programming
    Replies: 5
    Last Post: 11-24-2010, 12:06 PM
  3. numbers
    By Balen in forum Access
    Replies: 1
    Last Post: 08-17-2010, 05:16 PM
  4. Rounded Numbers
    By TundraMonkey in forum Access
    Replies: 3
    Last Post: 08-11-2009, 12:19 PM
  5. Set Numbers equal to each other
    By ygu3 in forum Access
    Replies: 1
    Last Post: 07-16-2009, 07:34 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums