| View previous topic :: View next topic |
| Author |
Message |
samuja
Joined: 21 Apr 2010
Posts: 2
|
 Posted: Sat Apr 24, 2010 10:41 am Post subject: Select single Entry from Database and insert into Exceltable |
 |
|
Hi ,
how to insert a single Entry from a mysql to an excel table.
like open a drop down menu and select the needed Entry ,
press RUN and its in excel
any suggestion appreciate
sam |
|
| Back to top |
|
 |
Sergei
Joined: 26 Jul 2007
Posts: 969
|
| Posted: Mon Apr 26, 2010 9:37 am Post subject: Re: Select single Entry from Database and insert into Excelt |
|
|
| samuja wrote: | Hi ,
how to insert a single Entry from a mysql to an excel table.
like open a drop down menu and select the needed Entry ,
press RUN and its in excel
any suggestion appreciate
sam |
If you need to insert a single entry/record/row from MySQL db to MS Excel you need:
1. Configure MySQL connector and write a SQL query in it that will pick up this entry.
2. Link MySQL connector to Transform operation and Transform to MS Excel connector that should be configured as well.
3. Within Transform operation you need to map the fields you would like to insert from MySQL to MS Excel.
3. Run and Preview results on MS Excel connector.
Regards,
Sergei |
|
| Back to top |
|
|
Guest
|
| Posted: Sat May 01, 2010 10:56 am Post subject: Re: Select single Entry from Database and insert into Excelt |
|
|
hi,
thank you for answer,
but its not dynamic, right ?
its only the ENTRY i select before exporting them to excel
i would like to have something like a form, which let me select via drop down menu from all entries
or may be i did not understand your answer ?
cin.
sam |
|
| Back to top |
|
|
Sergei
Joined: 26 Jul 2007
Posts: 969
|
| Posted: Mon May 03, 2010 9:58 am Post subject: |
|
|
Hello,
First, I advise you download Apatar and check its capabilities. There you can connect to your MySQL database and preview results and using different functions and operations you can export the entries you need.
Regards,
Sergei |
|
| Back to top |
|
|
Guest
|
| Posted: Mon May 03, 2010 10:36 pm Post subject: re: Select single Entry from Database and insert into Excelt |
|
|
hi, i did it 
but i dont know howto create such an option :S
sorry
may you could tell me
thnx
sam |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
