Results 1 to 4 of 4

Thread: Access to Excel

  1. #1
    Join Date
    Jan 2009

    Smile Unanswered: Access to Excel


    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.


  2. #2
    Join Date
    Nov 2004
    out on a limb
    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
    Thanks for your suggetion...

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


  4. #4
    Join Date
    Dec 2008

Posting Permissions

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