Results 1 to 3 of 3
  1. #1
    justinwright is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    104

    Import Excel file as report template - possible?

    The subject pretty much sums it up.



    Is it possible to import an excel file into Access as a report?

    I have an Excel file that looks like how I want the data presented, with the data filled in on the Excel sheet.

    If it's not possible, I take it I would have to export to the Excel file and print the Excel file? Does anyone have a few informational links handy on that, in that case?

    Thanks in advance for the help!

  2. #2
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    as far as I know, the report template feature in Access can only apply to actual report objects that are created and styled in Access itself.

  3. #3
    justinwright is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    104
    So I assume that means I'd need to export data to Excel?

    Would you happen to have any links handy for info on that (preferably something that just opened the file, exported the selected data to the excel sheet, printed the current sheet in the workbook, and closed the file without saving changes without any prompts or anything)?

    EDIT:

    I found some links for Exporting from Access to Excel, like here for anyone that needs:
    http://www.databasedev.co.uk/exporti...-with-vba.html
    http://www.vbforums.com/showthread.php?t=376693

    For Printing:
    http://forums.devx.com/archive/index.php/t-78786.html

    This is close to the cumulative problem:
    http://bytes.com/topic/access/answer...eport-printing

    I figured I'd post these for anyone else wondering, I'll mark this solved.

    Thanks for the help!
    Last edited by justinwright; 11-01-2010 at 09:40 AM.

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

Similar Threads

  1. Splitting an Excel File into Multiple Access Tables on Import
    By TheWolfster in forum Import/Export Data
    Replies: 4
    Last Post: 04-29-2010, 04:52 AM
  2. Exporting to a custom Excel template
    By theronlightfoot in forum Import/Export Data
    Replies: 2
    Last Post: 04-12-2010, 11:51 PM
  3. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM
  4. Report template requirement
    By pieniaszek in forum Reports
    Replies: 0
    Last Post: 07-29-2009, 07:25 PM
  5. Replies: 0
    Last Post: 04-29-2009, 04:27 PM

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