|
|
#1
05-07-2011, 10:09 PM
|
|||
|
|||
SQL help
Is there any way I can open a sql file? I had an a program that used a sql file to store my data. The cost went from zero to $1500 a year for subscription. Which I can't afford now. I have 20 years of customer data, job specifications and production costs in that file. Is there a away to open the file so I can read the information?
I applicate any help anyone can give me. Aloha, Mickey Mutt 
|
|
#2
05-08-2011, 03:06 AM
|
||||
|
||||
|
An SQL file?
You mean a database right? SQL is the language used to access the database. The format the file is stored is proprietary to the vendor. Ms access can be accessed by SQL. Oracle, IBM db2, mySQL, postgres ... All programs that can use SQL to access the files. If it was a proprietary windows app, then there is a good chance it was a MS Access format file (Potentially a JET driver if it was an old enough program). Without knowing the underlying database, then you are kinda hosed. Once you do know, you can install an appropriate odbc driver and access the file from excel.
__________________
“Simplicity is the ultimate sophistication.” - Leonardo da Vinci "I am a firm believer in the people. If given the truth they can be depended upon to meet any national crisis. The great point is to bring them the real facts...and beer." - Abraham Lincoln "... connect the dots instead of assembling a jigsaw puzzle." - Wil Wheaton
|
|
#3
05-08-2011, 08:15 AM
|
||||
|
||||
|
Alternatively, you might be able to straight up open the file in a text editor and 'see' the data.
If that is the case you should be able to processing the data to turn it in to a CSV or similar which can then be imported in to any database quite easily regardless of the original database used.
__________________
Steam: http://steamcommunity.com/id/tehboris Last edited by tehboris : 05-08-2011 at 08:15 AM.
|
 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|||||
Linear Mode
