I am trying to open, and view a couple of files used in an SQL database. The main program is called TAS (Tool Accountability System), and the main database is a .mdf file. When the database is backed up, the file is a .dat file. I am trying to open the file on my ubuntu machine, and have run into problems. I have found that Openoffice can open the .dat file. but I don't know how the information is input in to the file. Openoffice asks about the character set, and that is where I'm stuck. There are too many choices to try and do a line by line, so I need to know if there is a way to find this out. As for the .mdf file, I am just stuck. I've tried to search for answers, but I can't find any.
I want to open the files because the program in general keeps dumping tool boxes, and it takes time to restore or rebuild. Too much time for the bosses.
As a programmer, I have not dealt with SQL in any way, so I am unfamiliar with it. And help would be greatly appreciated.
Viewing database files
Page 1 of 13 Replies - 1192 Views - Last Post: 27 April 2012 - 05:47 AM
Replies To: Viewing database files
#2
Re: Viewing database files
Posted 25 April 2012 - 12:51 PM
.mdf is access
I dont understand this part
I dont understand this part
Quote
I am trying to open the file on my ubuntu machine, and have run into problems. I have found that Openoffice can open the .dat file. but I don't know how the information is input in to the file
#3
Re: Viewing database files
Posted 25 April 2012 - 12:56 PM
excel doesn't like it either. When I try to open the file in Openoffice, it asks for the character set. thats the info about it i dont have. Obviously without that info i cant see the correct data in it.
#4
Re: Viewing database files
Posted 27 April 2012 - 05:47 AM
Have you tried just changing the extension type to open it or open it with notepad?
Make sure you have backups before you mess with it.
Can the dump not be changed to another type?
Light reading if it will help in any way.
Also it could possibly be a csv.
Make sure you have backups before you mess with it.
Can the dump not be changed to another type?
Light reading if it will help in any way.
Also it could possibly be a csv.
Page 1 of 1
|
|

New Topic/Question
Reply



MultiQuote




|