Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    import not working properly (97)

    I

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: import not working properly (97)

    Format the column in the Excel file as Date and scan the first 35 rows or so to make sure that there are nothing but dates entered.

    Another option is to resign yourself to importing the field as text, and subsequently go into Design view of the resulting table and change the data type of that field from Text to Date/Time. 10 to 1 that there is a value in that field that is keeping it from being imported as a Date/Time field in the first place, though. HTH.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

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