Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    yellowdragon is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    9

    I have problems importing data. The errors are with the date fields. When I change the date fields to text it seems to work fine. The date is imported as text is this format, 2012-07-24. I tried all kinds of different setting but this is the only one that I could get to work. I think I'm ok with the fields all being text. I would guess that I need to change the fields in any of the other tables that are being updated by this table to text?

  2. #17
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    If you are importing the data into a temporary table, you can use a query to change the date to the format you want prior to appending it to your regular table. If you are importing directly into your regular table then you either have to change the source data prior to importing or run an update query after the append. In any case, I would strongly recommend that you have the same datatype for all data fields throughout your all of your tables. If you keep the date as text, it would be best to convert them to dates as you need them. Likewise if users enter dates as date,you would have to convert them to text. How do you want to display dates mm/dd/yyyy format? dd/mm/yyyy format.

    BTW, Access stores dates as a number with the portion to the left of the decimal point representing the number of days since 12/31/1899. The portion of the number to the right of the decimal point is used for the time and is stored as a fraction of a day (i.e. 0.5=noon)

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help creating a simple form
    By mattmurdock in forum Forms
    Replies: 3
    Last Post: 06-18-2012, 11:27 AM
  2. Creating a simple query?
    By hlm15 in forum Queries
    Replies: 3
    Last Post: 11-28-2011, 04:52 PM
  3. Replies: 7
    Last Post: 08-04-2011, 07:49 PM
  4. Creating a simple report?
    By berni3883 in forum Reports
    Replies: 1
    Last Post: 03-29-2011, 12:31 PM
  5. Creating a simple filter
    By Kipster1203 in forum Reports
    Replies: 3
    Last Post: 05-18-2010, 10:00 AM

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