Hi, i need to upload this Excel file on msAccess Db. I know how I do that, but i need to export an Excel File under certain criterias.

For Example i need to run a query that pull out on 3 different excel files for this field criteria "RRC", "Techmex", "Azlan".

How can I export onto Excel in 3 differents Excel Files.
RRC.xls, Techmex.xls, Azlan.XLS
Any example would be very helpful for me.


Thank you.

I am not sure from your post exactly what it is you are trying to do? Are you trying to query 3 excel files, and take those results and save them to a fourth excel file?

If that is the case, the problem is that you can't export this kind of query. What I would do is to create a local Access table that has the fields you need from your query, then do this:

Delete all the data in the local Access table first every time you run this routine.
Query the excel files and append the results to the local Access table.
Then export the local Access table to Excel.

Did that help any?

mmcdonal

Look it up at: http://wrox.books24x7.com

I would to explain better.
I hava a single XLS file that containt records which including countries, distribuitor, resallers and so.
E.G
ID Country Distribuitor QuoteNumber Date... so on
1 USA Technet 12 11-dec-07
2 USA Telmex 56 20-jan-07
3 CAN Ingram 33 11-aug-07
4 CAN Brightstar 44 23-jul-07
5 POLAND Techdata 56 15-dec-07
6 POLAND Fineinc 23 23-dec-07

There ihave to uplaod this file on a ms access for run the query that will delete records with 0 prices (easy) and change format date, etc
But the most important thing is when the filter have been applied I have to save on multiples workbooks on an specific folder for each country as distribuitors
Such as this example

USA-Technet.xls
USA-Telmex.xls
CAN-Ingram.xls
CAN-Brightsta.xls
POLAND-Techdata.xls
POLAND-Findinc.xls

And so for each country and dist.

I would appreciate any help to work with this.
Thanks

Hi gfranco

I am guessing from the way you have written your post that you are wanting to export out individual workbooks for each customer in their respective countries. If I am right and assuming this is going to be a one off exercise, I find the easiest way to do this is do as mmcdonnell suggested and bring the excel file into a local Access table. Using that table as the basis, create a single query, manually type in each country/supplier into the criteria section. Save the query and then go to file and export. This gives you the option of where to save and name the file, however if you are going to be doing this on a regular basis, then I would certainly look at automating this. I have a few databases that do this kind of operation and should you require it I can send you some VBA code to help.

Hope this is useful

Martin

Tell them they will hear,
Show them they will see,
Let them experience and they will learn

Thank you Martin, I would really appreciate any help that you might have. I have to do this automatically because I will have more than 50 files on excel.
My email is [email protected] if you want me to send some code or let me know where can I download.
Thanks.