Results 1 to 4 of 4

Thread: Access to Excel

  1. #1
    Join Date
    Jan 2009
    Posts
    7

    Smile Unanswered: Access to Excel

    Hi,

    I have an access database which contains around 2 lakh line items with 300 unique id.

    I need to save all the data points of the perticular unique id into seperate excel file each. i.e can say for 300 unique id there will be 300 Excel file.

    I do not if this can be done in Access by any Macro or any thisng else.

    Can any one pls suggest if this can happen in access.

    Regards
    santosh

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    is this a one off requirement or is it going to be a regular occurance?

    if its a one off I'd open Excel and run a series of queries to retrieve the data I need.
    if your SQL & office integration skills are good enough you could probably have a single Excel worksheet and extract the data as required.

    if its a regular occurance then I'd write some VBA in Access to 'push' the data into an Excel spreadhseet. there some good stuff int eh code bank for talking to Excel from Access.. I think its by Pootleflump and others
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2009
    Posts
    7
    Thanks for your suggetion...

    I am not too good in vba, can you pls help in getting this to be done in excel.

    regards
    santosh

  4. #4
    Join Date
    Dec 2008
    Posts
    59

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •