Search results

I think I found the problem. We had different permissions to the folder the access file is stored in.

Hi, My code is working just fine on my computer and I can update the access from my excel. When trying to do the same from one of my user's computer, I get this error message: "Run-time error '3251': Current Recordset does not support updating. This may be a limitation of the provider, or of the...

Working as expected!!! you made my day, can't thank you enough. J

Thanks. I believe the connection is working now, however..new issue: "run time error 3265 item could not be found in the collection corresponding to the requested name or ordinal". Here is the location of the error: Sub CopyDataFromExcelToAccess() Dim cn As ADODB.Connection Dim rs As...

Don't have spaces, still having the same error. Do I have to install any other drivers?

ok we solved the last issue. Now getting run time error with message "could not find file...". I check the location and name and they are correct but still got this message.

thank for your help. I copied and modified the code to fit the specific cells & DB fields. When running the code I get a compile error saying: "user-defined type not defined" and the code statement "Dim cn As ADODB.Connection" is highlighted. by the way, I'm using access2007 and excel 2010...

Hi all, Appreciate your help with this one: I have users filling data (in various cells) in excel template file. Each time a user is filling the same cells and saves the file. Is it possible with a macro/vba, that whenever the user saves the file, the data will be exported to a specific table...