data file conversion

calvinwels · Post by **calvinwels** » Fri Oct 09, 2009 8:26 pm

I have a rather large data file created using QBasic (and using MBF numeric data format). I hope at some point to try vBasic to mange this data file but would need to convert it to sdf format. Is there some utility that would convert a qbasic formatted data file to sdf for use in vbasic?
Thanks for your help

Post by **burger2227** » Fri Oct 09, 2009 8:35 pm

Microsoft Binary Format? Wow, that is historical data.

Why can't you just make a program to convert the data to a WRITE # or PRINT # format file? Those will work in VB.

calvinwels · Post by **calvinwels** » Fri Oct 09, 2009 9:02 pm

Thanks for the reply. If I create a new data file using a print # statement in a utility program, will I need to create an artificial extension on the file (eg mdf) for vb to recognize the file? VB certainly doesn't like the format in its current state.
Yes, the data in this file goes back to 1992 and is still in use.
Thanks again for your help

Post by **burger2227** » Sat Oct 10, 2009 12:05 am

I don't think ANY extension would affect VB. So use anything you want.

If you use WRITE, you can use a CSV extension so that Excel spreadsheets can read it too.

calvinwels · Post by **calvinwels** » Sat Oct 10, 2009 6:21 am

I'll give it a try and let you know.
Thanks again

calvinwels · Post by **calvinwels** » Mon Oct 12, 2009 4:31 pm

The file conversion worked as advertised! The data is now in a CSV file, so now on to getting the vb program up and running.
Thanks for your help.

Post by **burger2227** » Wed Oct 14, 2009 3:40 am

No problem! I hope that it works as planned. Many times I made the code in QB and could paste it directly into VB. Unfortunately those binary formats were not included in VB.

Good luck!