Qbasicnews.com
October 16, 2017, 11:01:00 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Back to Qbasicnews.com | QB Online Help | FAQ | Chat | All Basic Code | QB Knowledge Base
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Converting excel to qbasic  (Read 4861 times)
DJTREKBIKER
New Member

Posts: 1


« 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
Logged
Ninkazu
Been there, done that
*****
Posts: 1169



WWW
« Reply #1 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
Logged

am an asshole. Get used to it.
Clippy
Member
*
Posts: 84



« Reply #2 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.
Logged

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!