Hi guys,
I didn't think that the question I posted a long time ago would be of any interest to anybody. Anyway, if you ARE interested, I have this problem solved. Here's the code that works for me just fine:
---------------------------------
Option Explicit
Dim oconn As New ADODB.Connection...
Well, what can you do?
I guess, I'll try to check all these assumptions with different versions of Excel, ADO, DAO and so on for later use. And, compiling version, that works now, with references to the appropriate libraries should help, too.
Anyway, thanks a lot for all your help.
Best...
Frederico,
I think I finally figured out why it didn't work. I mean, I did try you code as Access Macro and it worked. I thought that the fact, that I actually wrote this piece in VB could be the reason it didn't work. But the code didn't seem any different to me until I noticed the one thing...
Hey Frederico,
I did try your version and unfortunately got the same result - all worksheets contain the same set of data, starting from record 1 to record 65536. Maybe it's version of Excel, that doesn't work appropriately with this method?
But as far as I remember there was nothing...
Frederico,
Sorry I'm late with my responses - probably time difference. I just got to work. Thanks again that you haven't given up on me. Just couple more questions:
1. This part in your code:
ws.Range("a100").CopyFromRecordset RS
ws1.Range("a100").CopyFromRecordset RS...
Frederico,
Thank you for your response. Sorry for posting my question twice. It's just there was no replies in one of them for a long time, so I decided to increase my chances by posting it again.
Anyway, from your code I didn't see how is the data in worksheet ws supposed to be different from...
Hello everyone,
I'm trying to write a piece of code, which would dump over 65536 records from Access database into Excel spreadsheet. Actually, I've got already couple of versions of this code working. But I can't get to work the most attractive one - using CopyFromRecordset method. In the...
Hello everyone,
I'm trying to write a piece of code, which would dump over 65536 records from Access database into Excel spreadsheet. Actually, I've got already couple of versions of this code working. But I can't get to work the most attractive one - using CopyFromRecordset method. In the...
Well, right you are.
But...
Not all the clients listen. Even to the best of analysts.
Thank you anyway for your suggestion.
I thought there might be something out there much like when you're archiving files and archive gets spanned by, say WinZip, over several disks.
Well, guess not in my case...
This - Excel file - is a format our client wants us to provide the data in. Nothing I can do about it. No comma-delimited .txt files is allowed. And no discussions, too. Client's always right!?
Hello SkipVought,
Thanks for your response. Unfortunately, I will need all the records at a time. I can do it by inserting record by record into worksheet, creating a new one each time the limit was reached, but it takes a lot of time. What I'm looking for is a way to speed this process up...
Hello everyone,
I have a question for you. Let's say I have a table in Access database and it has 100,000 records. I'd like to export this table's data to Excel spreadsheet. Docmd object has methods/actions OutputTo and TransferSpreadsheet to help to do this. But Excel has limits the number of...
Hello everyone,
I have a question for you. Let's say I have a table in Access database and it has 100,000 records. I'd like to export this table's data to Excel spreadsheet. Docmd object has methods/actions OutputTo and TransferSpreadsheet to help to do this. But Excel has limits the number of...
Hello everyone,
I have a question for you. I need to merge a few TIFF images. The images could be quite big - a few hundreds of pages in each one of them. I can do that using Kodak ImageEdit and ImageAdmin controls methods, but the process is very slow and could take hours. There's an...
vb5prgrmr,
I'm not sure if you'll look at this post again, but I just want to believe that you would and I want to tell you that it was very helpful. I'll give it a try.
Thanks a lot.
Hi vb5prgrmr,
First of all, thanks for your reply.
Secondly, no, I'm doing it locally and it kills me even thinking, that eventually I'll need to do it over the network. And I'm talking about batch processing of potentially tens of images of 100+ MB and 1000+ pages in each one.
So any help...
Hi everyone!
I have a question for you.
OK. Here goes.
I'm writing a utility which will go through all pages in a multi-page TIFF image in order to find landscaped pages, rotate them to make them portrait and save the image. There could be multiple TIFF images, so I need to perform batch...
In my program I need to make a pop-up window close automatically after user is done printing the content of this window. Does anyone know how to do it without getting any intermediate messages from the browser?<br>And one more thing - is there any way to load a page, keeping it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.