Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    U.S.
    Posts
    26

    Unanswered: Import Problems!!

    IM IMPORTING AN EXCEL FILE TO AN ACCESS PROJECT. IMPORTING WORKS GREAT, BUT WHEN I WANT TO CHANGE DATA (DATA SHEET VIEW) IN THE TABLE I HAVE IMPORTED TO, ACCESS GIVES ME A "THIS RECORD IS NOT UPDATABLE." ???? WHAT THE??? HOW DO I CHANGE DATA IN THE TABLE ONCE I HAVE IMPORTED THE DATA???

    ANY HELP WOULD BE GREAT

  2. #2
    Join Date
    May 2003
    Posts
    144
    I assume that you import the excel file into a temp table (which is displayed as the data sheet view). If my assumption is correct, make sure there is a primary key on your temp table.

  3. #3
    Join Date
    Jan 2004
    Location
    U.S.
    Posts
    26

    tHANX

    Originally posted by SHK
    I assume that you import the excel file into a temp table (which is displayed as the data sheet view). If my assumption is correct, make sure there is a primary key on your temp table.
    Thank you for taking the time to help me. The solution was what you suspected. Once again thanks!!

Posting Permissions

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