FiveTech Software tech support forums

Dear Mr.Harvey, Mr.Colin's sample is working fine for me. Here is a complete code based on Mr.Colin's sample http://img121.imageshack.us/img121/426/exceldata.jpg #include "Fivewin.ch"//----------------------------------//Function Main()        Local oExcel,oWorkBook...

Harvey

I am using xHarbour - and it works fine.

Regards

Colin

Thanks for the info. Compiled and got following error. Error description: Error 1519188/3 DISP_E_MEMBERNOTFOUND: CELLS Args: [ 1] = N 0 [ 2] = C A Stack Calls =========== Called from: => TOLEAUTO:CELLS(0) Called from: excel.prg => MAIN(26) What am I doing wrong. Using Harbour

Harvey bFile := {||'c:\awt\kyocera.xls'}oExcel := TOleAuto():New("Excel.Application")oExcel:WorkBooks:Open(eval(bFile))oSheet := oExcel:Get("ActiveSheet")oExcel:Visible := FALSEnRows := oSheet:UsedRange:Rows:Count()do whil...

1. How to import from a tab delimited file.
2. How to import directly from an xls file.

I have a very large file. I need to split this file into several pieces and save in MySQL database.

I'm using fopen / fread to read these parts of the file, but can not save them in a blob field in my database.

As I read the parts of the file to be able to write into the blob?

... Thank you for your reply. Indeed under processes it consumes 25% of CPU time. This program takes one huge CSV file and split it in 25,000 lines pieces. So, it is done splitting the file, but still remains in memory, or is it not done and remaining in memory? Maybe it is not done, and still working? ...

James:

Thank you for your reply. Indeed under processes it consumes 25% of CPU time. This program takes one huge CSV file and split it in 25,000 lines pieces.

... Ukoenig: Thank you for your responses. :D What I'm trying to do is process a huge (3.9GB) CSV file, read it line by line and split it in n lines pieces so I can import it to dbf files. I'm doing it because I have not found a single software that is able to import such a file. I think that the ...

have you the ER source codes?
I 'm working on it on free time, When I finish to work i insert it on Vide of fwh.Now run bad I have many pieces to try..

... data with the corresponding "aData" element. Obviously, both arrays must have the same number of elements. Example: aItems := { "Pieces", "Feet", "Gallons" } aData := { "PC", "FT", "GA" } nColum := 1 cField := "Unit" ...

Hello,

Do You need only the images or a function ?
I wrote a function, cuts a defined image in equal pieces
and creates button-bmp's from the result.



Regards
Uwe

... server xBase database (in FiveLinux) has been operating without a problem for some two weeks now. Just a suggestion - if you are sending multiple pieces of data in a message rather than using token delimiters (which then have to be excluded from any data that might be sent) consider sending arrays ...

... as many records in the memo file as you need for each record in the main file. You would also have to write code to chop the full length memo into pieces to store it, and more code to paste it all back together. You also need be able to auotmatically add and delete records as needed. Regards, James

... no more a Sub-Class. Now, TSBrowse is an independent control that inherits directly from TControl class. My work has mainly consisted on putting pieces together with some extra from my own crop. Credits: Luis Krause Mantilla Selim Anter Stan Littlefield Marshall Thomas Eric Yang John Stolte Harry ...