Recent content by Nicha

Smart words and smart advise @the_do. Answering your question, no, there's no process going over the intermediate query. At this point I will create the table in order to ferd the excel ms qwery, instead of create an CSV for that purpose. As Gasman said, the advantage of using the table is to...

Many thank's to you both @Gasman and @Minty.

Ok. @Gasman and @Minty, I've tried your sugestions, and I decided to follow that path. Regarding the question of using DAO or ADO, can you help? I've tested with DAO and worked fine.

Ok @Gasman. My best regatds. I'll wait for someone to answer my initial questions to build the complete orocess of extraction from passthrough. And as you nentioned, I'll use allways the same, created manualky, instead of creat the passthrough every time it runs. Thank you once more.

So, sumnarising your idea for my last question, first create table from passthrough query, and then export to csv using your function. Your function doesn't work on exporting directly from passthrough query? Thank you once more @Gasman

I'll try your ugestion @Gasman. Even so, can I ask you the best way (vba code) to export from access table to CSV? And wich is faster; export from Access temporary table or from the Passthrough?

The extraction will ocurr in a daily basis. So @Gasman, in your opinion, regarding my question "Would it be better to not export to CSV or link the MS Query directly to the Access table?" there's no need to export to CSV; It's better to Link directly to access Table wich seems to be faster...

I need to export data from an ORACLE database, and I'm using Access VBA. This involves running SQL via ODBC, using a Passthrough query that brings in about 1,300,000 records and takes about 15 minutes to run. I need to find the best way to do this. I'll describe what I did, but I'm not sure if...