• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 922
  • Last Modified:

How to DTS a .DAT extension file in the database?

I have SQL Server 2000 datbase. I want to DTS a .DAT extension.
How can I do that?
I cannot load it as text file if I try to the format looks crazy.
Can some tell me how to DTS a  .DAT extension file in the database?

  • 2
1 Solution
Chris MangusDatabase AdministratorCommented:
Where is the .DAT file coming from?
zeeshanbuttAuthor Commented:
A client provided us that file. I need to DTS it into the database.

Any idea?
Chris MangusDatabase AdministratorCommented:
You need to find out from the client what they exported the data from.  There are literally dozens of pieces of software that export data, each in their own formats for a .DAT file.

If you are able, I would have them send you the export in a very common format like CSV or XLS.
Are you sure it's not a database backup?
Sometimes sql backups are saved using the .DAT extension.

Beyond that, you really need to find out what the format is, and as cmangus says, try asking them for csv instead.


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now