OK, I tried the viewer that was suggested by OlafDoshke and was able to open the files. Since the application is a shareware item, I was able to only view/export 100 files. I found another program CCVT.exe that allowed me to convert the Clarion *.dat files to dBase III files, which could be viewed in Excel or imported into Access. I have hit two hurdles with this . . .
1) the field names came over a bit scrambled (i.e. in the conversion, the field names were changed to first three letters of the table name and then some characters from the field name; not all, some) - I corrected this by viewing the *.dat files field names then converting the dBase III files to Excel and editing the field names there. I could then import into Access with no field name issues. What this highlighted is that some fields which were in the *.dat files apparently were blank and therefore were not transferred to the dBase III files. So I added columns in the Excel for these fields, but really feel unsure about whether they should be there at all. Any suggestions?
2) One of the pieces of data is a float in the dBase III files. When I bring this field into Excel, it looks fine, but when I import to Access from Excel, it looks like this - 1.5010960E+11. I tried importing from dBase III, but got the same results. I believe this to be an error due to the size of the field or type of data. Any suggestions?
Thanks again to everyone, this has got me started, which was the first big hurdle. Also, if anyone has any more insight into the Clarion DB structure (important files, easy ways to determine linked fields from table to table, etc.) that would be appreciated too!
Regards,
pbt1234