Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > BOOK: Professional Access 2013 Programming
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 31st, 2014, 02: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.
Reply With Quote
  #2 (permalink)  
Old January 31st, 2014, 10:15 PM
Registered User
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 8
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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 04:02 AM
Problem with creating ASP .NET web app/service reye VS.NET 2002/2003 1 December 28th, 2006 05: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 10:33 AM



All times are GMT -4. The time now is 08:51 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.