dht files

[Guest]

I have a file with a .dht extension I would like to import into an Access
table. It doesn't appear to be possible.

I can import it into an Excel file and then import that table into Access,
but I'm getting errors on the 2nd import. I'd like to be able to skip the
Excel step to see where the problem might reside.

Is there a way to import .dht into Access?

 

[Arvin Meyer [MVP]]

try opening it in bote pad to see if it's a plain text file, or one with a
header. If it is, strip off the header or use it as the first row, and
change the file extension to txt or csv so Access will read it.

 

[Larry Linson]

I have a file with a .dht extension I would like to import into an Access
table. It doesn't appear to be possible.

I can import it into an Excel file and then import that table into Access,
but I'm getting errors on the 2nd import. I'd like to be able to skip the
Excel step to see where the problem might reside.

Is there a way to import .dht into Access?

All I was able to determine by Googling is that a .dht (among other
definitions) is a Gauss datafile -- no more than that. At least one "Gauss"
software package is a Mathematics and Statistics System (see
http://www.aptech.com/). But, of course, anyone can use any file extension
for any file just by renaming it. Gauss datafiles, per se, are not a
supported file type for direct import.

If you can do it via Excel, then diagnosing the cause of the error may be
worthwhile, and pursuing going through Excel may be useful.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks to you both. Excel looks like the best way - as usual.