Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Converting excel to qbasic
#1
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
Reply
#2
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
am an asshole. Get used to it.
Reply
#3
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.
Get my QB demonstrator here: http://dl.dropbox.com/u/8440706/Q-Basics.zip
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)