Thanks Gearhead for your help with this. I've managed to import the .DAT files into MSAccess now by writing my own code to read the header information and then analyse the data within the files. It's not perfect yet by any stretch of the imagination but I'm getting there. You helped me a lot...
Gearhead,
Thanks for taking the time to reply again, appreciate it.
I've been analysing one of the .DAT files and have been able to read most of the data. The one thing I'm having problems with are the dates and times which I was expecting. The format of the date and time is not a problem as...
Hi Gearhead,
Thanks very much for your help. I still have a couple of questions though!
To start with, I wondered why you mentioned the date/time fields in Clarion. Are these stored as some magical information only known to the inner workings of the Clarion database? I took a quick look at...
Hi all,
I am contemplating writing an import routine within MSAccess that reads the information in the .DAT files as binary input. I believe I can work out the file lengths, record and field sizes as well as the field names from the .DAT files.
If I go ahead with this can anyone see any...
Hi all,
Please could someone help me before I lose my mind... For info I have no experience of Clarion or TopSpeed.
I too am having problems linking an Access2000 database to what I think is a Clarion database. I have been sent files that have the extension of .DAT which I am told are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.