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 gkittelson 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. MaureenL

    Issue with copyfromrecordset and cursorlocation

    That is why on each loop I am adding another worksheet with an additional number. The problem is with adUseClient it doesn't remember when it is. adUseServer will end up with one worksheet with 64999, and another worksheet with 9000,
  2. MaureenL

    Issue with copyfromrecordset and cursorlocation

    I am trying to copy a large ADO recordset to Excel. If I define the cursorlocation as adUseServer , the rst copies the first 64999 records over, loops and then copies the remaining 9000 records. I can't define it this way or I get other issues on some people's pcs " Error Number: 430 Error...
  3. MaureenL

    Unprintable characters as terminators in GENTRAN

    I am having issues with using a CR (HEX 0d) as a terminator in GENTRAN. We have used unprintable characters as terminators for quite some time, including 0d0a (CRLF). Sometimes the 0d will be ignored and I end up with segments concatenated together. Gentran said they do not support...

Part and Inventory Search

Back
Top