Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Oakland, CA, USA
    Posts
    161
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import data from Excel (Access 97)

    Hello, I've successfully imported an XL spreadsheet into Access. 3 of the columns/field are date fields. The dates show as regular numbers now in Access even though they were formated to date format in XL. I go to design view and change the Data Type and the properties to show date/time - short date. When I click on save to go back to Datasheet View it gives me the error msg: "Access encountered errors while converting the data. The contents of fields 974 (could be a diff. no.) records were deleted. Do you want to proceed anyway?". Well, if I proceed it deletes ALL the data of the fields containing dates. What am I missing????? Can anyone help please? Thank you, Tira

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Import data from Excel (Access 97)

    Did you import to an existing table or created one from the import?
    What is the actual format of the date field in the access table, I presume it's a text field or is it a long integer?
    You may have to convert the 3 columns into 3 date columns via an update query.
    Post the excel sheet and I am sure that people will give it a go.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Import data from Excel (Access 97)

    Most often this happens because one of the cells in the workbook doesn't contain a date that is valid, or is empty or contains text. Save your Excel file as a CSV (comma separated values), and then import the text file. The text import wizard will let you decide the format/data type that you want in the new table. Another alternative is to create the table manually before you do the import and specify the date fields at that point. You may get a few import errors if some the the values aren't dates, but it will tell you which ones weren't in the Import Error table.
    Wendell

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Oakland, CA, USA
    Posts
    161
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import data from Excel (Access 97)

    I tried to convert it to a csv file, imported it again and, so far;-)), it works great. Thanks for your help Pat and Wendell.

    Tira

Posting Permissions

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