Shows Schedule Inside Revision3 Store

Go Back   Revision3 Forums > Shows > HAK5

Thread Tools Search this Thread Display Modes

Old 05-07-2011, 10:09 PM
Join Date: Dec 2008
Posts: 15
Status: Offline
Default 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.


Mickey Mutt
Reply With Quote
Old 05-08-2011, 03:06 AM
tokenuser's Avatar
Cranky Old Mod
Join Date: Jul 2005
Location: Lost in States
Posts: 15,126
Status: Offline

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
Reply With Quote
Old 05-08-2011, 08:15 AM
tehboris's Avatar
Elite Member
Join Date: Jun 2007
Location: England
Posts: 1,532
Status: Offline

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.

Last edited by tehboris : 05-08-2011 at 08:15 AM.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT. The time now is 06:06 PM.

Rev3 Forum RSS

© 2005-2010 Revision3 Corporation