SST and CONTINUE records

  • Thread starter Thread starter arun.darra
  • Start date Start date
A

arun.darra

Hi,

This is very urgent so please help me out with this.

I am creating a Excel file using the Biff8 format. My excel file has
two string
1 string is of 10 bytes in length and the other is 12K in length.

Both the strings are writen into the SST record, the way Im writing it
is
SST Header | Data length | String 1 | String 2
but since String 2 is 12K in lnegth it over flows the maximum record
lenth of 8228.
So I add only the first string to the SST record and then add a
CONTINUE record and add the second string to it.

But my Excel sheet when displayed is blank. The size of the file is
equivalent to the data in it but when displayed thru excel it is blank.

Any hints or guidanced will by greatly appreciated.

Thanks in advance

Regards
Arun
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

String variables 3
SQL not importing records from ACCDB 2
dget or dsum, that is the question 2
number as string and adding spaces to it 2
Save Text to File 3
printer page length 1
Public fixed length string variable 2
Excel 2003 VBA In directory Open Spreadsheets Extract data 1

Back
Top