How to import xml into excel then automate advanced filter

[handsrfull]

Here is what I am trying to accomplish:

I have a xml file that I need to open in excel, then need to sort for unique records, then need to sort one column for (Non-blanks). I then would like to save the excel file and import it into a database as an excel table.

Is there an easy way to accomplish this? I have to do this same routine daily and I would like to automate it.

I have tried importing the xml directly into acces, however it breaks the xml file up into multiple tables.

If anyone knows how to get the xml file to import into access as one table that would be even better.

 

[Gavona]

Someone else will give a much better answer but I do know that you can copy and paste all the data from Excel into an Access table - maybe that would do it for you?


Gavin

 

[SkipVought]

Hi,

Rather than OPEN this file, use Data > Import External Data > IMPORT...

Also, check out LINKING your workbook TABLE (SHEET) to the database, rather than IMPORTING each time.

Skip,
[sub]
Just got a nuance...
to replace the old subtlety![/sub]