I've started working with Millinium software 3.2 and want to transfer summary of the area counts and file names directly into an excel spreadsheet. I can not find a nice way to do it. I have tried the ascII file but it ends up getting corrupted by shifting the data into different rows. Any help would be appreciated.

Create a summary report in Millennium that looks like what you want.

Create an export method to export that report as an ascii file (I used the default delimeters) to a designated subdirectory .

Select your processed results, from the tools menu choose export, choose your method and click OK.

Open the created file with excel.

I did this to see if it would work, and it did. It took about 2 minutes.

A.A.

Thanks for the quick response. I had done that. I set up a report of all the areas and samples on the run and placed it on the same report. Then I exported it to and ascii file. When I opened it some of the rows were intermingled with data from the previous row. This happens several times on a 20 injection run.

Where you transfering one file at a time? With other software I have been able to transfer the entire run at one time and just cut and paste. I would have all the data for peak 1 in one column and put it in my spreadsheet and do the calculation for the entire run for peak 1.

Why do you need to transfer the data to excel? Millennium can probably do the calculations for you.

Dear Memerick,
First of all, I must apologize, I did my experiment on version 4. Going back to version 3.2, I found the same problem as you. However I also found a work around by creating an export method using the fields tab. I used the parameters on this page to create a summary table which exported cleanly to Excel.

Check with Waters, maybe there is a service pack to fix that bug.

Itīs also possible to copy and paste a peak table out of the report publisherīs preview.
We use this method to evaluate data in excel without manual input.

Memerick,

I just tried Caro's method and it (of course) worked just fine. As you can probably tell, I don't export data to Excel very often (never actually). The right click, copy, paste method from preview is way easier then the export method method.

By the way..

If you have empty cells in your table (missing peaks), the copy-paste routine will overwrite the empty cells with the following values. Ensure that your table is complete.

The cute Millennium-globe in the left upper egde is also not copied to excel. You have to adjust the first line (one step to the right).

For further information: e-mail (leaving the lab noe for an ice-cream at Haegen-Dasz...)

You all have been a great help. I wasn't aware of just coping and pasting. I will give that a shot. If that dosn't work I will try the field tab before the export. The reason we are using the Excel files are they are validated and in our SOP's. Thanks again.