Appendix G. Importing Files into Excel
Step 3 of 3
A quick look at the columns of data is provided in the Data Preview group box.
Highlight the column with the year/month/day and from the Column Data
Format group box, select the Date option. From the drop down list box to the
right of this option select the YMD format.
To complete the import, select the Finish button.
As imported, the Date and Time fields have a quotation mark in the field.
"TOACI1"
"CR10T"
"FiveSecond"
"TMSTAMP" "RECNBR" "counter" "SineOut" "IntTemp_C" "BattVolt"
"2002-01-17 16:31:45"
19787
340
-0.342
23.83
13.96
"2002-01-17 16:31:50"
19788
22
0.375
23.83
13.97
"2002-01-17 16:31:55"
19789
62
0.883
23.83
13.97
"2002-01-17 16:32:00"
19790
102
0.978
23.83
13.97
"2002-01-17 16:32:05"
19791
142
0.616
23.83
13.96
"2002-01-17 16:32:10"
19792
182
-0.035
23.83
13.97
G-6
Summary of Contents for LoggerNet
Page 2: ......
Page 30: ...Preface What s New in LoggerNet 4 xxvi...
Page 32: ...Section 1 System Requirements 1 2...
Page 44: ...Section 2 Installation Operation and Backup Procedures 2 12...
Page 136: ...Section 4 Setting up Datalogger Networks 4 80...
Page 227: ...Section 7 Creating and Editing Datalogger Programs 7 9...
Page 298: ...Section 7 Creating and Editing Datalogger Programs 7 80...
Page 402: ...Section 9 Automating Tasks with Task Master 9 12...
Page 406: ...Section 9 Automating Tasks with Task Master 9 16...
Page 450: ...Section 11 Utilities Installed with LoggerNet Admin and LoggerNet Remote 11 22...
Page 454: ...Section 12 Optional Client Applications Available for LoggerNet 12 4...
Page 462: ...Section 13 Implementing Advanced Communications Links 13 8...
Page 482: ...Section 14 Troubleshooting Guide 14 20...
Page 570: ...Appendix F Calibration and Zeroing F 16...
Page 578: ...Appendix G Importing Files into Excel G 8...
Page 579: ......