Thanks Ashish for the great support !!!
Please try to solve the query of RajaSekhar as it is also important for me.
Thanks again !!!!
On Tue, Oct 23, 2012 at 1:17 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Hi Ashish,
>
> Adding to below i do maintain huge data base of access but if i want to
> export to excel i am facing the problem
>
> as there are more than 2lac rows or records in access Just require ur
> expertise can i use the same macro which is listed below if so please
> advise the sql command to get for example
>
> to export complete details in batches wise
>
> 1st record to 60000 th record like wise.
>
> Thanks,
> Raj
>
>
> On Sun, Oct 21, 2012 at 10:13 PM, ashish koul <koul.ash...@gmail.com>wrote:
>
>> Option Compare Database
>>
>> Private Sub Command11_Click()
>> ' Add microsoft Excel
>> ' ADD aTIEVEX DATA OBJECT
>>
>> Dim xla As Excel.Application
>> Dim wk As Excel.Workbook
>> Dim cn As New ADODB.Connection
>> Dim rs As New ADODB.Recordset
>> Dim j As Long
>>
>> Set cn = CurrentProject.Connection
>> qry = "select * from Details where [Details].[Details] like '%" &
>> Me.Text12.Value & "%'"
>> rs.Open qry, cn, adOpenDynamic, adLockOptimistic
>>
>> If rs.EOF = True Then
>> MsgBox "No Records found", vbInformation, "Note: "
>> rs.Close
>> cn.Close
>> Exit Sub
>> End If
>>
>>
>> Set xla = New Excel.Application
>> Set wk = xla.Workbooks.Add
>>
>> For i = 0 To rs.Fields.Count - 1
>> wk.Sheets(1).Cells(1, i + 1).Value = rs.Fields(i).Name
>> Next
>>
>>
>> wk.Sheets(1).Range("A2").CopyFromRecordset rs
>> wk.Sheets(1).UsedRange.EntireColumn.AutoFit
>> xla.Visible = True
>>
>> End Sub
>>
>>
>> On Sun, Oct 21, 2012 at 9:24 PM, Mangesh Vimay
>> <mangesh.da...@gmail.com>wrote:
>>
>>> Deal ALL,
>>>
>>> Please help me on above issue.
>>> Please !!!
>>>
>>>
>>> With regards,
>>>
>>> Mangesh
>>>
>>>
>>> On Sat, Oct 20, 2012 at 11:08 PM, Mangesh Vimay <mangesh.da...@gmail.com
>>> > wrote:
>>>
>>>> Hi Ashish,
>>>>
>>>> It is for just exporting result set to Excel.
>>>> But, I need code for search criteria as well.
>>>>
>>>> Please do needful.
>>>>
>>>> Thanks !!!
>>>>
>>>> With regards,
>>>>
>>>> Mangesh
>>>>
>>>>
>>>> On Sat, Oct 20, 2012 at 10:32 PM, ashish koul <koul.ash...@gmail.com>wrote:
>>>>
>>>>> just make small changes in this file and it will work as per your
>>>>> requirement
>>>>>
>>>>>
>>>>> http://accessvbaprogramming.wordpress.com/2012/09/18/type-sql-query-in-text-box-in-access-form-and-export-output-to-excel/
>>>>>
>>>>>
>>>>>
>>>>> On Sat, Oct 20, 2012 at 10:30 PM, Mangesh Vimay <
>>>>> mangesh.da...@gmail.com> wrote:
>>>>>
>>>>>> Hi Noorain,
>>>>>>
>>>>>> Thank you so much for your reply.
>>>>>> I have attached database file (sample) to show you what exact I need.
>>>>>> Please find the file "Temp".
>>>>>> In Temp we have two objects
>>>>>> Table - Detail
>>>>>> Form - City Details
>>>>>> In the Form I have inserted search criteria text box in which if I
>>>>>> enter the text "Capital" and click on the Search button. Then It should
>>>>>> export the result into Excel file with the result set like below :
>>>>>> ID City Details 3 Mumbai Financial Capital of India 6 Delhi Capital
>>>>>> of India
>>>>>> So I get above output in excel file because it is containing the
>>>>>> string "capital".
>>>>>> It can be done by Macro.
>>>>>> And please help- me on this.
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> With regards
>>>>>>
>>>>>> Mangesh
>>>>>>
>>>>>>
>>>>>> On Sat, Oct 20, 2012 at 6:35 AM, NOORAIN ANSARI <
>>>>>> noorain.ans...@gmail.com> wrote:
>>>>>>
>>>>>>> Dear mangesh,
>>>>>>>
>>>>>>> Please see attached access database. Hope it will help to you.
>>>>>>>
>>>>>>>
>>>>>>> On Sat, Oct 20, 2012 at 12:20 AM, Mangesh Vimay <
>>>>>>> mangesh.da...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hi Friends,
>>>>>>>>
>>>>>>>> I am using MS Access 2007.
>>>>>>>> I have table called "City".
>>>>>>>> The table "City" contains the information of the different cities of
>>>>>>>> INDIA with their details.
>>>>>>>>
>>>>>>>> For example,
>>>>>>>> City Details
>>>>>>>> Mumbai It is the Financial capital of India
>>>>>>>> Delhi Capital of India
>>>>>>>> I have also form for retrieving details of the city
>>>>>>>> It contains the drop down list for all cities of India
>>>>>>>> If I select Mumbai from the drop down list, then it should display
>>>>>>>> the details.
>>>>>>>> However, I have another search option i.e. "Search by Keyword"
>>>>>>>> In Search by keyword, if we enter any string from the details
>>>>>>>> column.
>>>>>>>> It should display all records that consists the specified string.
>>>>>>>> For example, if we enter the string "capital" in text box, then it
>>>>>>>> should display all records containing the string "capital".
>>>>>>>> I need the macro (or any other solution) to do this.
>>>>>>>> I hope, I am able to explain what I need.
>>>>>>>> I know, this group is dedicated to MS Excel only. But I also know
>>>>>>>> there are many experts who does well in Access as well.
>>>>>>>>
>>>>>>>> So I request all please help me by providing suitable solutions.
>>>>>>>> Appreciate your help !!!
>>>>>>>>
>>>>>>>> Thanks in Advance !!!
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> With regards,
>>>>>>>>
>>>>>>>> *MaNgEsH*
>>>>>>>>
>>>>>>>> --
>>>>>>>> Join official facebook page of this forum @
>>>>>>>> https://www.facebook.com/discussexcel
>>>>>>>>
>>>>>>>> FORUM RULES (1120+ members already BANNED for violation)
>>>>>>>>
>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>>
>>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>>
>>>>>>>> 3) Don't post questions regarding breaking or bypassing any
>>>>>>>> security measure.
>>>>>>>>
>>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>>
>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>>>>> forum in signatures are prohibited.
>>>>>>>>
>>>>>>>> 6) Jobs posting is not allowed.
>>>>>>>>
>>>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>>>>> allowed.
>>>>>>>>
>>>>>>>> NOTE : Don't ever post personal or confidential data in a
>>>>>>>> workbook. Forum owners and members are not responsible for any loss.
>>>>>>>> ---
>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>>>>> To unsubscribe from this group, send email to
>>>>>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> With Regards,
>>>>>>> Noorain Ansari
>>>>>>> http://
>>>>>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
>>>>>>> http://
>>>>>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> With regards,
>>>>>>
>>>>>> *MaNgEsH*
>>>>>>
>>>>>> --
>>>>>> Join official facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES (1120+ members already BANNED for violation)
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>>
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>
>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>> in signatures are prohibited.
>>>>>>
>>>>>> 6) Jobs posting is not allowed.
>>>>>>
>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>>> allowed.
>>>>>>
>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>> Forum owners and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>>> To unsubscribe from this group, send email to
>>>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Regards*
>>>>> * *
>>>>> *Ashish Koul*
>>>>>
>>>>>
>>>>> *Visit*
>>>>> *http://www.excelvbamacros.com/*
>>>>> *http://www.accessvbamacros.com/*
>>>>>
>>>>> P Before printing, think about the environment.
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Join official facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES (1120+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>> 2) Don't post a question in the thread of another member.
>>>>>
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>>
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>
>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> 6) Jobs posting is not allowed.
>>>>>
>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>> allowed.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>>> To unsubscribe from this group, send email to
>>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> With regards,
>>>>
>>>> *MaNgEsH*
>>>>
>>>>
>>>
>>>
>>> --
>>> With regards,
>>>
>>> *MaNgEsH*
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> --
> Thanks & Regards,
> Rajasekhar.P
>
> Subscribe to our group and receive daily updates.
> Excel groups
>
> https://sites.google.com/site/excelencyclopedia/how-to-join/assignments
>
> Send your queries and Suggestions @
> excel-gro...@googglegroups.com
>
> Excelforum Blogspot
>
> <a href="
> http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US<http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US>">Subscribe
> to excel forum by Email</a>
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
--
With regards,
*MaNgEsH*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
