Qbasicnews.com

QBasic => QB Discussion & Programming Help => Topic started by: DJTREKBIKER on June 03, 2009, 04:32:12 PM



Title: Converting excel to qbasic
Post by: DJTREKBIKER on June 03, 2009, 04:32:12 PM
Hi All
I have been causually trying to convert excel spreadsheets to qbasic .dat files for some time now and have had no luck.  I can convert a qbasic .dat files to excel but can't figure out how to get them back again.
Can anyone help with this?
Dan


Title: Re: Converting excel to qbasic
Post by: Ninkazu on June 04, 2009, 09:29:56 AM
xls or csv? CSV is pretty easy since it's just comma-separated for different columns with new lines to go to the next row, but xls is a lot more complex. Here you can find format details for different versions of the format http://www.wotsit.org/list.asp?al=X


Title: Re: Converting excel to qbasic
Post by: Clippy on June 04, 2009, 03:19:07 PM
QB can use WRITE to created Comma Separated Variable files. The row count of variables is fixed. Are the files you are accessing CSV files? You should be able to open the files in Notepad or Wordpad to check them.

If all that you see are weird symbols, then the file may be binary format.