Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
Please vote in the Forum Structure Poll. Polling will close at 2PM EST on January 21, 2025.

MS ACCESS import help

DeebaserDeebaser on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
edited April 2012 in Help / Advice Forum
Someone on my team has imported a file. This file has some rows with null values, particularly in the first row. When they import and set the field type as datetime, if there is a null, access converts the entire column to GENERAL (ie 2/15/2012 becomes 49054).

This is annoying.

Short of ensuring the columns in the first entry are not null (impossible), is there a workaround to force a column to be datetime?

Thanks!

Deebaser on

Posts

  • tastydonutstastydonuts Registered User regular
    Are you doing advanced settings and specifying that it is a date when importing? which version of access is this?

    “I used to draw, hard to admit that I used to draw...”
  • DeebaserDeebaser on my way to work in a suit and a tie Ahhhh...come on fucking guyRegistered User regular
    2007 and yes, she is specifying that the field is datetime.
    Access is saying "fuck you" in response.

  • tastydonutstastydonuts Registered User regular
    Yea, I just dicked around with that scenario myself. Curious though, why isn't she able to scrub the data?

    Worst case, datetime as a number is still usable, she'd just have to convert to date first in any calculations?

    “I used to draw, hard to admit that I used to draw...”
  • BowenBowen Sup? Registered User regular
    Open file, find "NULL" or "null" replace with "" ?

Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum