Rama | 2007-11-23 03:36:13.0 | |
| Hi All,
I have bought HXTT Excel Driver.I need a small help. My requirement is to group the data. Can the groupby clause work with HXTT Excel? . If it works please provide the syntax. username:allenjesson@bigpond.com please help me how i can resolve it. Thanking you in advance. Regards, Rama. | ||
HXTT Support | 2007-11-23 03:49:01.0 | |
| Supports. It's listed at Select syntax.
| ||
Rama | 2007-11-23 04:17:42.0 | |
| Hi all,
sorry to say that i have seen but the query is not able to retrieve all the data eventhough it satisfies the condition. even with distinct clause also i am getting only partial data.I have posted in the technical support but i didnot get any response. I dont know the reason. please help me in resolving this. It is very urgent. Here is my query. select TrackId from sheet1 GROUP BY AdGroup. Thanking you in advance, username:allenjesson@bigpond.com Regards, Rama. | ||
HXTT Support | 2007-11-23 05:10:20.0 | |
| >I have posted in the technical support but i didnot get any response.
Sorry. It seems that we missed your question. | ||
HXTT Support | 2007-11-23 05:15:13.0 | |
| >select TrackId from sheet1 GROUP BY AdGroup.
>even with distinct clause also i am getting only partial data. It's supported by HXTT Excel. What's your issue? You can email us a xls sample so that we can check it. | ||
Rama | 2007-11-23 20:58:15.0 | |
| Hi All,
Thanks for your support.i have sent the .xls in zip format to the email address webmaster@hxtt.com. please refer to it.its very urgent. Thanks In Advance. Regards, Rama | ||
HXTT Support | 2007-11-25 05:03:28.0 | |
| Supported. Please download the latest package. | ||
rama | 2007-11-25 21:17:26.0 | |
| Hi All,
Sorry to say that i have downloaded the latest Excel JDBC 3.0 Package file but there is no difference between the latest one and previous one. i am very disappointed with this.i tryed both DISTINCT and GROUPBY clauses both are not working or i have to dowload another jar please guide me on this issue. Regards, Rama | ||
HXTT Support | 2007-11-25 21:31:34.0 | |
| >Sorry to say that i have downloaded the latest Excel JDBC 3.0 Package file
You download v1.1.075 on 2007-09-28, but its' v2.0.008 now:) Please login and download:) | ||
Rama | 2007-11-25 22:16:12.0 | |
| Hi All,
Thanks for your response.But in the files list of download page i am seeing only the files with names Excel JDBC 3.0 and Excel JDBC 2.0 etc.... how would i know that whether it is v1.1.075 or v2.0.008. please guide me on this issue. Thanks in advance. Regards, Rama | ||
HXTT Support | 2007-11-25 22:22:51.0 | |
| >i am seeing only the files with names Excel JDBC 3.0 and Excel JDBC 2.0 etc....
Because we provide the latest package with JDBC3.0, 2.0, and 1.2 support. >how would i know that whether it is v1.1.075 or v2.0.008. java -cp ./Excel_JDBC30.jar com.hxtt.sql.excel.ExcelDriver . | ||