XlsImport

forum.td.development (2005-2010)
CharLi Solutions

XlsImport

Post by CharLi Solutions » 04 Jun 2010, 07:59

 Posted by:  CharLi Solutions 

Hi All,
Is there any possibility to read the data from Xls file (i.e., Shell by
shell) and insert into database ?

that is importing excel file data in sql server database

i am using TD 1.5 .

Much appreciation if you could provide some sample file in CTD
1.5.1

Thanks
Regards,
Balaji S

FRBhote
India
Posts: 1231
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

XlsImport

Post by FRBhote » 04 Jun 2010, 10:29

 Posted by:  F R Bhote 

What we normally do is save teh xls file as a csv and then import it using
SalStrTokenize.

CharLi Solutions

XlsImport

Post by CharLi Solutions » 04 Jun 2010, 15:08

 Posted by:  CharLi Solutions 

Hi F R Bhote

Thanks for the raply
But this SalstrTokenize is noramlly used for csv format

But i need to import directly from xls format which converting into csv
format

Thanks
Regards
Balaji S

Return to “td.development”

Who is online

Users browsing this forum: No registered users and 0 guests