By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes
   dbr983 : -2147217900 The INSERT INTO statement contains the following unknown field name: 'dt_accessed'. Make sure you have typed the name correctly, and try the operation again.insert into listaccess (dt_accessed,list_id,userid,ip_addr) values ('12/2/2021 2:17:37 AM',33467,-1,'34.207.247.69')

listi.net

 


2011-05-17 The Files are Different

Today a user calls me to complain that a file I sent them is very different than a previous file I sent.

So how do you compare two files against each other? I use a spreadsheet called CompareSheets.xls to determine the differences. The program will:

1. Get you to select the two files you want to compare
2. Press a button to start the comparison
3. Compare the data cell by cell and display a list of differences

After the comparison runs the sheet allows me to step by step view the differences in the two files. I examine the data and notice that the differences are caused by the user adding a formula while the sheet was filtered on one sheet but not the other.

This is a case where developing tools for my work paid off. I was quickly able to diagnose the problem.

It also reminds me that you should always compare output against a previous working or validated output to make sure you haven't changed anything.
blog comments powered by Disqus
   
Home | About | Feedback| Privacy | Terms of Service | @alecberg | FAQ | | Copyright © 2021 All Rights Reserved. Edit
This site uses cookies. If you don't want cookies and who doesn't want them as they're yummy, then leave.