Import data From MS Excel

[Do Mai Huy]

 Posted by:  Do Mai Huy 

Help me Please

I need inport data from Ms Excel to my database. I using CT 1.51 and MS Sql
2000 Server.
Please send sample for me or Show me how to do.

Thank you

DMH

[FRBhote]

 Posted by:  F R Bhote 

Save the excel as .CSV (or .TSV). Then :

While SalFileGetStr( hFile, sLine, 2000 )
Call SalStrTokenize( sLine, '', ',', sArray )

sArray[0], [1], .... are the excel columns.

[Do Mai Huy]

 Posted by:  Do Mai Huy 

Thank you F R Bhote

But can you show me more detail how to do or load sample file for me .

Thank so much

[premcmenon]

 Posted by:  Prem Menon 

Hi Do Mai Huy ,

This attached app file will read a xl - dbf file directly and insert the
content into a child table. you can update this code with a pushbutton which
will inserts the data into a database from the child window. you need xl -
activex libs to run this code. remember i am checking for a blank row for
breaking to loop , so the blank row show be the last row in ur xl file. let
me knw if u dn't hv apls.

-prem

[Jeff Luther]

 Posted by:  Jeff Luther 

Prem - thanks for your sample! What is also helpful, however, is for you to
also include any APL libs. along with your APP file, zip all of them, and
submit that as your attachment.

You've got Excel 10.0 included in your app, but I only have a stub of that
version and cannot get your sample to compile. (And trying Excel 9.0 and 11.0
generate compile errors as well.)

Without the particular version of MS Office installed, others might not be
able to generate Excel 10.0 themselves. This has been the issue with so
many samples that include MS and other APLs: there's an APL version
dependency that is often difficult to duplicate. Thanks.

- Jeff

[Mark Silver]

 Posted by:  Mark Silver 

Hi, maybe you can try this directly

select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;DATABASE=C:\movs.xls', 'Select * from [page1$]')

[Peter Tosh]

 Posted by:  Peter Tosh 

With query analyser Sql process the statement correctly, but I nee to use it
directly as
Call SqlPrepareAndExecute( hSql, "SELECT * FROM OPENROWSET(
'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=C:\\TMP\\movs.xls', 'SELECT *
FROM [INDEX$]' )" )
but TD 1.5.1 return OLE/DB error
Microsoft SQL Server:7312[Microsoft][ODBC SQL Server Driver][SQL
Server][OLE/DB provider returned message: Il modulo di gestione di database
Microsoft Jet non è riuscito a trovare l'oggetto 'I
Could not be right the sintax of statement?
Should hSql cursor be defined in particular mode?
Someone have a solution?
Tanks
PT