xwei1031 Member X Join Date Jun 2015 Location Canada Posts 5 Aug 28, 2015 #1 Hey Guys, Is it possible to show the data from the .dat file taken from datalog to a display in the form of a list view similar to that of Microsoft Excel? Many Thanks
Hey Guys, Is it possible to show the data from the .dat file taken from datalog to a display in the form of a list view similar to that of Microsoft Excel? Many Thanks
xwei1031 Member OP X Join Date Jun 2015 Location Canada Posts 5 Sep 9, 2015 #2 Problem Partially Solved, The list view can be achieved through using an ODBC data base and be opened through VBA's DAO feature.
Problem Partially Solved, The list view can be achieved through using an ODBC data base and be opened through VBA's DAO feature.
jkerekes Member Join Date Aug 2007 Location NJ Posts 2,362 Sep 9, 2015 #3 Rockwell has a utility to convert .dat files to .csv, I believe, or possibly .xls. I don't remember at the moment.
Rockwell has a utility to convert .dat files to .csv, I believe, or possibly .xls. I don't remember at the moment.
xwei1031 Member OP X Join Date Jun 2015 Location Canada Posts 5 Sep 10, 2015 #4 That is correct, but the problem with excel is that the data is not current. Access can be used to obtain the most recent data!
That is correct, but the problem with excel is that the data is not current. Access can be used to obtain the most recent data!
jkerekes Member Join Date Aug 2007 Location NJ Posts 2,362 Sep 10, 2015 #5 But the .dat file is proprietary. Are you now logging data to an OBDC database instead?