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???
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!!