Search results

  1. A

    Problem with code to extract data from excel to access 2010

    Hi, any further help will be really appreciated. Thanks.
  2. A

    Problem with code to extract data from excel to access 2010

    Hi, thank you both. I made both changes: Changed "OpenDatabase" to "Currentdb" and "dbOpenTable" to "dbOpenDynaset", this removed the error I was getting, which btw was the in the following line: rst.FindFirst "[Identification #] = '" & Dato1 & "'" However, I'm still having my first record...
  3. A

    Problem with code to extract data from excel to access 2010

    Thanks Cronk, I added the code you suggested as follows, however it says that "Operation is not supported for this type of object", maybe I'm placing it in the wrong place: Obj_Excel.Workbooks.Open FileName:=Path_XLS Set Obj_Hoja = Obj_Excel.Sheets("CCN-TCN-CIN Form")...
  4. A

    Problem with code to extract data from excel to access 2010

    Hi, I'm new to this forum, I've been struggling for some weeks now with a code to pull out some data from an excel template to my Access database, I got some help with the original code and then I did some upgrades, however, everytime I run it, I get all my information in the Access table as...
Back
Top Bottom