Page 1 of 1
Data Transfer into Excel from Stand-alone PC
Posted: Wed Feb 16, 2011 1:51 pm
by chillipadi
Hi,
I'm a newbie for using GC. All these while, I had been manually typing the calibration data (area / conc) into an excel spreadsheet (LAN PC). All my GCs are stand-alone and there's no connection to LAN. Is there any way to transfer the data into excel via LIMS function or macro? Currently we are able to transfer data into LIMS via labfx.
Really appreciate help as it's quite tedious having to type 20+ components into excel spreadsheet.
My GC chemstation is B.04.02
How about GCMS as well?
Thank you.
Re: Data Transfer into Excel from Stand-alone PC
Posted: Wed Feb 16, 2011 10:01 pm
by chemtexpps
Your system must have MS-OFFICE S/W with Excel.
while printing the report go to LOAD THE DATA FILE REPORT..>SPECIFY REPORT....>CHECK THE .XLS BOX and go to report ...> print report.
Then go to your " C" DRIVE .... HP CHEM OR CHEM32........1----DATA....GO TO THE ABOVE DATA FILE FOLDER YOU WILL SEE XL FILE just open the file and click on the bottom tabs.All the data got transfered to your Excel file. Hope this will help you.
Re: Data Transfer into Excel from Stand-alone PC
Posted: Wed Feb 16, 2011 11:14 pm
by chillipadi
Is it possible to transfer the generated excel file from the stand alone pc to another LAN pc?
Re: Data Transfer into Excel from Stand-alone PC
Posted: Thu Feb 17, 2011 12:37 am
by tom jupille
Is it possible to transfer the generated excel file from the stand alone pc to another LAN pc?
Files is files. As long as you can access the other PC, you can copy and paste. In the worst case, copy it to a USB "thumb drive" and use "sneakernet".
Re: Data Transfer into Excel from Stand-alone PC
Posted: Thu Feb 17, 2011 6:08 pm
by carl.nott
Is it possible to transfer the generated excel file from the stand alone pc to another LAN pc?
Easiest way is with a LAN. If you absolutely cannot use a LAN I'd recommend something simple like a manual 2-port USB switch and an external hard drive. Connect stand alone and LAN PC to switch, switch to external hdd, copy files from stand alone to hdd, flip switch, copy/access files with LAN PC. The switch solution is more complicated if you're running an old OS on the stand alone which needs USB drivers.