Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional Access 2013 Programming
This is the forum to discuss the Wrox book Professional Access 2013 Programming by Teresa Hennig, Ben Clothier, George Hepworth, Dagi (Doug) Yudovich; ISBN: 978-1-118-53083-2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Access 2013 Programming section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 31st, 2014, 03:52 PM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2014
Location: Toronto, ON, Canada
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating Excel file from Access Web App

Using Access Web application I would like to use a custom search form to select data and then export it to Excel. I have done this in client Access using TransferSpreadsheet, but there is no such thing in web app.
  #2 (permalink)  
Old January 31st, 2014, 11:15 PM
Registered User
Points: 27, Level: 1
Points: 27, Level: 1 Points: 27, Level: 1 Points: 27, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You are right. There isn't a way to export a spreadsheet from an Access web app into Excel. What you can do instead is create an Excel workbook and link it to the datasource you want to use in the SQL Server -- or SQL Azure -- database behind the web app. The Excel sheet can be put into a document library on your SharePoint site for sharing with users. We discuss this approach in the book.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating custom item templates for my web app goose BOOK: Beginning ASP.NET 4 : in C# and VB 3 August 6th, 2013 06:56 AM
Creating Excel File vikas67k C# 6 March 4th, 2010 05:02 AM
Problem with creating ASP .NET web app/service reye VS.NET 2002/2003 1 December 28th, 2006 06:10 AM
VB.Net + Web App. + Access Database SeemaChivate ADO.NET 6 July 7th, 2005 04:06 AM
file transfers over mobile asp.net web app badgolfer ASP.NET 1.0 and 1.1 Basics 1 November 15th, 2004 11:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.