Re:XlsImport

forum.3rdparty.tools (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Re:XlsImport

Post by NewsgroupServer » 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

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Re:XlsImport

Post by NewsgroupServer » 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.

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Re:XlsImport

Post by NewsgroupServer » 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 “3rdparty.tools”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests