Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

opening a .dat file

Status
Not open for further replies.
bschmitz

bschmitz

Programmer
Apr 16, 2002
17
US
I was sent a .dat file and have tried to open it with EM using both the Import data wizard and the restore DB wizard but neither wizard gives me a source option of .dat. Is this possible? Am I doing something wrong? Thanks in advance for your help.
 
Sort by date Sort by votes
Try double clicking the file name in Windows explorer and see if it opens up in Notepad or Wordpad. You might also try renaming the file and change its .dat to .doc and see what application opens when you click on it.
 
Upvote 0 Downvote
It opens up as a lot of square boxes and symbols.
 
Upvote 0 Downvote
Thanks garyd1 for the help. A colleague of mine has shown me the light.
 
Upvote 0 Downvote
FYI - I had to copy the .dat file to the c drive of the server that houses our SQL DBs. I was trying to do it across a network.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
686
Mike Lewis
Mike Lewis
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
892
SashaBuilder3
SashaBuilder3
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
601
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
793
Andrzejek
Andrzejek
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
1K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top