Saving Datapage results in Excel

[Paul Sarrach]

When I save Datapage results in Excel, everthing the data for each reading is in on cell seperated by commas. How can I seperate the data so it will have its own cell. If this is not clear enough, is there any one out there that excels in Excel that can email me. And I will call and explain what I am trying to do.

Thanks
Paul

[\v/inston]

create a report in datapage. click File\Save to file\Save All Reports\ name it 'something.txt' go into your main Datapage folder and find the .txt file you just saved. change the file extension to .xls. and it should put the data in separate columns for you.

[Doug Wells]

Paul;

In addition to the default 'tab' setting for the delimiter, I add the 'space' and 'tab' options. I also check the box to treat consecutive delimiters as one.

Hope this helps,

Doug Wells

[T Miller]

I use spreadsheet save then open excel and open the text file a window will open make sure delimited is checked should be ok..
If you have a lot of header info you may want to edit it out of the text file first
It doesn't seem to be a problem leaving it in tho

[NZ CMM Girl]

It sounds like your data is comma delimited. When you open a non-excel file in excel it should ask you if your data is delimited or in fixed width columns. If you choose delimited, then you can select the delimiter - in your case it would be comma.

Hope this helps!!
Lenice

[david phillips]

I Save the datapage spread sheet as a .txt. (data page set up for comma seperated)
Open exel.
Data/external data import/ import data/ browse for saved .txt file

text import wizard step 1
delimited
start import row "1"
file Origin "437: OEM united states
Next>

step 2
delimiters "Comma"
next>

step3
column data format
General
Finish
OK

then I click on cell "PART"
Click on DATA-Filter-Auto Filter

this way I can pull data just for a specific part.
also copy and paste that data to inspection sheet.

I do the same import for Varible information.
which tells me what LOC1.D is. "Datum A OD"

[jleond]

Just save the report as xls file, example: report1.xls, then open it directly with excel.