Lennie Kuah

Lennie Kuah

  • NA
  • 29
  • 0

VbNEt2008 Format Excel 2003 Spreadsheet cells

Jun 19 2011 10:49 PM
Hullo Friends,
I need your help. Please help me.

I am using VbNet2008 window  application to transfer data from SQL SERVER table to Excel 2003  Spreadsheet.

The SQL SERVER table datatype is nvarchar : 00612 and when transfer to Excel spreadsheet cell it appeared at 612 instead of 00612. Also another SQLSERVER table data 0(934,21) appeared as (934,21) instead of 0(934,21)

Problem is how to format the spreadsheet cells ?
How's the coding looks like.
Please share with me. Thank You.


Cheers,
Lennie Kuah