Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    14

    Unanswered: Exporting from access to excell

    I need some help on making an automated export from access to excel, but i need different filtrated things to be exported. I can't explain it exactly and that's why i am attaching a sample video of what i want.

    Of course on the upper band there will be more things like week, type of product, price etc.

    I am doing a daily report and i want to make it as automated as possible, and i think that there must be a way to export the information from excel directly where i want i excel.
    Attached Files Attached Files
    Last edited by watermariana; 08-28-09 at 05:19.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    Watching a videa isn't really an option for me right now. AS such, I don't know if this works for you but have you seen:
    http://www.dbforums.com/6222281-post4.html
    ???
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If you could just explain it, it would make it much easier.

    There are some good exporting examples (one which lets you view/edit access tables as an excel table as well as then export them out to an excel file (giving you the ability to select the folder/filename, etc...). You can find these examples in the code-bank.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    May 2007
    Posts
    14
    I will try to explain.

    I have an access table that has many parameters such as month, week, target group, address, quantity, etc.

    I want to export for example the quantities filtrated for two weeks in a certain cell in excel. Then on the next cell in excell i want the same two weeks and the quantities for them, but filtrated by target group.

    Does this make sense now ?

    Thanks in advance!

Posting Permissions

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