|
Posted by David Portas on 10/18/05 16:26
Do you know what format the file is? .DAT could be anything because
plenty of different applications and data sources use DAT as a file
extension. If you know what format the file is then you can proceed to
look for an ODBC driver for that format.
If you really have no idea then try taking a look at the file in a hex
editor or file viewer. Maybe there will be something in the header that
indicates the source. Otherwise you may have to consult whoever was the
originator of the file.
If the file is in some readable text format like a delimited or fixed
width ASCII file then you could use DTS to import it.
Maybe this is in fact a SQL Server database file with a non-standard
file extension. In that case you may be able to attach it using
sp_attach_single_file_db so take a look at that topic in Books Online.
If you do attempt that, make sure you have a backup of the file first
because the server may write to the file.
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|