You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sanjiv Kumar <kt...@gmail.com> on 2016/05/18 05:57:32 UTC
Re: Regarding Excel Files and Ms Access File.
This is my second mail regarding excel file (.xsl file) and Ms Access Files.
When Drill provide Storage Plugin for Excel File And Ms Access File?
And When Drill latest version 1.7 is going to be release.? Can i
aspect that Storage Plugin for excel file will be there in Latest
Version (i.e 1.7)??
......................
Thanks & Regards
*Sanjiv Kumar*
Re: Regarding Excel Files and Ms Access File.
Posted by Khurram Faraaz <kf...@maprtech.com>.
Sanjiv you can try to export your data from MS Excel file to a text/CSV
file, using the Save As option. and then query that CSV/text file from
Drill.
On Thu, May 19, 2016 at 12:38 AM, Antonio Romero (carnorom) <
carnorom@cisco.com> wrote:
> http://ucanaccess.sourceforge.net/site.html
>
> This would let you connect to Microsoft access via generic JDBC. Solves
> one big piece of your problem. I think there is something similar for Excel.
>
> Sent from my iPhone
>
> > On May 17, 2016, at 10:57 PM, "Sanjiv Kumar" <kt...@gmail.com>
> wrote:
> >
> > This is my second mail regarding excel file (.xsl file) and Ms Access
> Files.
> >
> > When Drill provide Storage Plugin for Excel File And Ms Access File?
> >
> > And When Drill latest version 1.7 is going to be release.? Can i
> > aspect that Storage Plugin for excel file will be there in Latest
> > Version (i.e 1.7)??
> >
> >
> >
> >
> >
> >
> >
> >
> > ......................
> > Thanks & Regards
> > *Sanjiv Kumar*
>
Re: Regarding Excel Files and Ms Access File.
Posted by "Antonio Romero (carnorom)" <ca...@cisco.com>.
http://ucanaccess.sourceforge.net/site.html
This would let you connect to Microsoft access via generic JDBC. Solves one big piece of your problem. I think there is something similar for Excel.
Sent from my iPhone
> On May 17, 2016, at 10:57 PM, "Sanjiv Kumar" <kt...@gmail.com> wrote:
>
> This is my second mail regarding excel file (.xsl file) and Ms Access Files.
>
> When Drill provide Storage Plugin for Excel File And Ms Access File?
>
> And When Drill latest version 1.7 is going to be release.? Can i
> aspect that Storage Plugin for excel file will be there in Latest
> Version (i.e 1.7)??
>
>
>
>
>
>
>
>
> ......................
> Thanks & Regards
> *Sanjiv Kumar*
Re: Regarding Excel Files and Ms Access File.
Posted by Ted Dunning <te...@gmail.com>.
Sanjiv,
Would you like to help build such a plugin?
One place to start would be the Apache POI project which would help you
read Microsoft documents.
From there, you need to decide how you want to handle issues like multiple
sheets, non-uniformly gridded data and such.
At that point, it wouldn't be too hard to copy one of the existing plugins
to get what you want.
On Wed, May 18, 2016 at 12:01 PM, Zelaine Fong <zf...@maprtech.com> wrote:
> Sanjiv,
>
> As noted in the reply to your first email on this question, Drill does not
> currently have such a plugin. We're in the process of re-evaluating the
> release cadence of Drill, and will no longer be doing releases on a monthly
> cadence. At this time, we do not have a firm date for the next release,
> but it likely be in the next couple of months.
>
> -- Zelaine
>
> On Tue, May 17, 2016 at 10:57 PM, Sanjiv Kumar <kt...@gmail.com>
> wrote:
>
> > This is my second mail regarding excel file (.xsl file) and Ms Access
> > Files.
> >
> > When Drill provide Storage Plugin for Excel File And Ms Access File?
> >
> > And When Drill latest version 1.7 is going to be release.? Can i
> > aspect that Storage Plugin for excel file will be there in Latest
> > Version (i.e 1.7)??
> >
> >
> >
> >
> >
> >
> >
> >
> > ......................
> > Thanks & Regards
> > *Sanjiv Kumar*
> >
>
Re: Regarding Excel Files and Ms Access File.
Posted by Zelaine Fong <zf...@maprtech.com>.
Sanjiv,
As noted in the reply to your first email on this question, Drill does not
currently have such a plugin. We're in the process of re-evaluating the
release cadence of Drill, and will no longer be doing releases on a monthly
cadence. At this time, we do not have a firm date for the next release,
but it likely be in the next couple of months.
-- Zelaine
On Tue, May 17, 2016 at 10:57 PM, Sanjiv Kumar <kt...@gmail.com> wrote:
> This is my second mail regarding excel file (.xsl file) and Ms Access
> Files.
>
> When Drill provide Storage Plugin for Excel File And Ms Access File?
>
> And When Drill latest version 1.7 is going to be release.? Can i
> aspect that Storage Plugin for excel file will be there in Latest
> Version (i.e 1.7)??
>
>
>
>
>
>
>
>
> ......................
> Thanks & Regards
> *Sanjiv Kumar*
>