Search results

Without the type conversions, I get type mismatches since Acc and Cl are both stored as Integers in the xl file. Without the aliases I get the same error message ( "..updateable query") Modifying the qImp with cStr conversions on Acc and Cl still yields the same error message. As mentioned...

@Cronk, Apologies SC was a type of "CL" qImp SELECT DISTINCT S.[Acc], S.[Cl], S.[XD], S.[PD], S.[Div] FROM [Excel 8.0;HDR=YES;IMEX=1;Database=H:\Dist.xls].[Sheet1$A1:DL65536] AS S; @CJ, that's another one I tried, but I still get the same error: "Operation must use an updateable query"...

Hi all, hoping you can help me with the following. (I've just inherited a databse from a predecessor that I need to make a few ammendments too) I have a table (tDist) that users are updating manually based off an excel file. I've written a query (qImp) to take the relevant data from the file...

Hey there, I've been using Excel VBA for a while now and am looking to solution things on Access. I have some SQL experience but find that there are many nuances to Access that cause me problems and that's why I'm here ;)