Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VMacedo

    VBA Excel with SQL

    Did you can see the worksheet and analyze? How I can send to you?
  2. VMacedo

    VBA Excel with SQL

    My problem happen when I update my consult. The consult filter datas of a base sheet. Initially this base sheet have 54700 rows, and the consult 528 rows. When I duplicate the rows of the base sheet (109400 rows) the consult teorically duplicate too, right? But the number of rows drops to 397.
  3. VMacedo

    VBA Excel with SQL

    Judgeh59, Answering the Skips question: Yes, I have 1048576 rows in a new sheet. And, after some tests, I realized that when the SQL comes in the row number 65656, he stop, descards all the consult and restart from the row 65657.
  4. VMacedo

    VBA Excel with SQL

    Unfortunately has not yet. The extension of my worksheet is .xlsm and the version of my Excel is 2007, don't have sense.
  5. VMacedo

    VBA Excel with SQL

    Man, my problem persist! I don't know why, but, I did a little test and yet don't is correct.
  6. VMacedo

    VBA Excel with SQL

    Hi, I have a worksheet in Excel with more of 65000 rows and I wanna export to the other worksheet using the VBA and SQL codes, but, when come to the row number 65656, the SQL stop the consult! I'm using the version 2007 of Excel, theoretically, this version have more of 1 million of rows, so why...

Part and Inventory Search

Back
Top