Importing data from .dat extension file to SQL Server

Importing data from .dat extension file to SQL Server

Post by Tibor Karasz » Sat, 25 Nov 2000 04:00:00


You probably have to go and ask the person who created the file what program created
the file. Perhaps BCP in native mode?

Tibor Karaszi, SQL Server MVP
Neil's FAQ at:
Please reply to the newsgroup only, not by email.


I was wondering if any of you out there has tried importing data from .dat
extension file type to SQL Server database.  I understand that DTS wizard allows
importing data from different database sources as well as importing text file
into SQL Server db but somehow it doesn't recoginze the .dat extension file
format as it does not contain delimiter I suppose.

Was wondering if any of you has any ideas in going about to solve this problem.
I've included the file together with this posting.

Any suggestion will be appeciated. Thanks in advance.



1. Unknown data format, file extension is .dat

September 15


I've been presented with the data files from two different custom-written
DOS programs. Both of 'em were written before 1990. I don't know what kind
of data files these are - they have the file extension .dat. I don't see a
list of field names at the beginning of the files. They appear to be
straight data. I can read the alpha fields but it _appears_ that the date
and number fields are in binary.

Does anyone know of a utility that will identify the file format of a data
file? If I just knew what the format was, it would be a terrific help!

Very truly yours,
Rex B. Hamilton

2. HELP! VFP - listboxes on pageframe have odd behavior

3. importing Oracle's DAT files into SQL Server

4. Long Island - ORACLE/SYBASE on NT and/or Unix clients - Client needs developers in NY and NJ

5. Importing SQL-Server 6.5 .DAT file

6. 46855-Nationwide-DBA Skills-ORACLE-PeopleSoft-Oracle DBA-PeopleSoft/DBA Consultants

7. .dat file extension

8. FM Pro5 -Is it possible to read TOC from cdroms?

9. Accessing dbase files with the extension .dat

10. Reading a file using Microsoft Text Driver with an extension .dat

11. Accessing dbase files with the extension .dat

12. .dat and .idx file extensions

13. Attach SQL Server 6.5 dat file back to SQL Server