Results 1 to 2 of 2
  1. 10-11-2011, 12:39 PM #1
    Anvictus
    Anvictus is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Oct 2011
    Posts
    1

    Exporting date field using MS Excel

    I am learning to use access. I am importing date fields from excel. The fields are time stamped, which I don't want. How can I avoid the time stamp?
    Reply With Quote Reply With Quote
  2. 10-11-2011, 07:56 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,963
    Depends how you are doing the import. If you are using the wizard, probably have to take them in and fix later.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. exporting to Excel
    By johnririe in forum Import/Export Data
    Replies: 6
    Last Post: 08-23-2011, 10:16 AM
  2. Exporting Lookup Field To Excel
    By HarryScofs in forum Access
    Replies: 1
    Last Post: 07-27-2011, 09:42 AM
  3. Exporting to Excel
    By TheDeceived in forum Programming
    Replies: 0
    Last Post: 11-15-2010, 08:56 AM
  4. Exporting field to excel
    By Kipster1203 in forum Import/Export Data
    Replies: 5
    Last Post: 08-12-2010, 03:07 PM
  5. Exporting to Excel Date Stamped File
    By BED in forum Import/Export Data
    Replies: 1
    Last Post: 08-07-2010, 05:53 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums