Results 1 to 6 of 6
  1. #1
    hutchinsm is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    3

    Export Table in Access 2007 to Multiple Workbooks in Excel 2007

    Hello All,



    I'm a newbie here. I need to see if someone can provide me with the VBA code to export a table that does a filter by city on a large customer table and produces separate Excel workbooks that have the Customer information for each respective City. I've found several different scripts through google, but none of them seem to work for Access 2007.

    Can anyone provide me with a simple script?

    Thanks,
    Hutch

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Each case of Access/Excel interaction is usually quite unique and it is unlikely will find a ready-to-use procedure for your circumstances.

    You need to attempt code from the numerous examples available and when you have specific issue post question. Maybe this will get you started http://www.access-programmers.co.uk/...d.php?t=191123
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    hutchinsm is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    3
    Quote Originally Posted by June7 View Post
    Each case of Access/Excel interaction is usually quite unique and it is unlikely will find a ready-to-use procedure for your circumstances.

    You need to attempt code from the numerous examples available and when you have specific issue post question. Maybe this will get you started http://www.access-programmers.co.uk/...d.php?t=191123

    Looks like you misread my request. I'm looking for the code that take a table in Access and break it into separate Excel Workbook files based on the City in the Customer table we have. So anyone who has this code for version 2007, I would be most grateful.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I did not misread your post. I said there isn't a canned script to offer. I pointed you to a link that demonstrates what can be involved in Access/Excel interaction coding and that you will have to use this and other examples to develop code tailored for your situation. The second example in that link is a procedure to write a table to multiple worksheets. Here are more references:
    http://msaccess.blogspot.com/2005/04...using-vba.html
    http://www.mrexcel.com/forum/showthread.php?t=62704
    http://www.access-programmers.co.uk/...d.php?t=157331
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    hutchinsm is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    3
    Quote Originally Posted by June7 View Post
    I did not misread your post. I said there isn't a canned script to offer. I pointed you to a link that demonstrates what can be involved in Access/Excel interaction coding and that you will have to use this and other examples to develop code tailored for your situation. The second example in that link is a procedure to write a table to multiple worksheets. Here are more references:
    http://msaccess.blogspot.com/2005/04...using-vba.html
    http://www.mrexcel.com/forum/showthread.php?t=62704
    http://www.access-programmers.co.uk/...d.php?t=157331
    You're still misreading my request!! I NEED SEPARATE WORKBOOK FILES! Not separate sheets in the same file. GET IT NOW?

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    No, I understand your question and doesn't matter - same workbook, different workbook, separate worksheets, whatever - the examples are offered only to give you ideas and show what is involved and how variable the approach can be. I doubt you will find ready-to-use procedure for your situation. Here are two more that might be closer to what you want
    http://www.accessmvp.com/KDSnell/EXCEL_Export.htm
    http://www.accessibledatasolutions.c...essToExcel.htm

    Attempt coding for your situation and when you encounter specific issue, post question.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Ms Access 2007 report export to excel 2007
    By Stan2man in forum Access
    Replies: 6
    Last Post: 11-23-2011, 01:24 PM
  2. Access to Excel 2007 export annoyance
    By jim wv in forum Import/Export Data
    Replies: 3
    Last Post: 10-14-2011, 09:48 AM
  3. Replies: 3
    Last Post: 08-18-2011, 05:04 PM
  4. Export table from Oracle to Microsoft Access 2007
    By dba in forum Import/Export Data
    Replies: 1
    Last Post: 02-25-2011, 07:05 AM
  5. Replies: 0
    Last Post: 11-17-2009, 02:35 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums