Importing into Excel or Access is fairly simple to do, however, we would benefit greatly if the format of the CSV file could be tweaked. In order for Excel or Access to import the Date and Time fields they need to be in a format of mm/dd/yyyy hh:nn:ss. Currently they are broken into mmm dd, yyyy, hh:nn AM. With this format you can only import as text fields and therefore cannot create meaningful graphs/reports. I've tried many of these applications and GB is the best I've tried so far. It just needs a few tweaks. If GB could provide the Date/Time field as ONE field formatted as mentioned above, it would be a great improvement.
|