Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-15-2018, 06:40 PM   #1
QueryStumped
Newly Registered User
 
Join Date: Mar 2017
Posts: 27
Thanks: 19
Thanked 0 Times in 0 Posts
QueryStumped is on a distinguished road
Excel spreadsheet

Hello...looking for some guidance... I have an Excel spreadsheet that is printed out like a coversheet. It's fed off a query that is export out, feeding different cells on the coversheet. Is there a way to import the excel coversheet into Access, having it feed off the same query.

QueryStumped is offline   Reply With Quote
Old 09-15-2018, 08:23 PM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 8,996
Thanks: 10
Thanked 2,160 Times in 2,115 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Excel spreadsheet

No. If you want access to produce some formatted output you are going to have to format it yourself. It can definitely run off a query to use it's data, but there's no way to import a layout
plog is online now   Reply With Quote
The Following User Says Thank You to plog For This Useful Post:
QueryStumped (09-16-2018)
Old 09-16-2018, 03:37 AM   #3
QueryStumped
Newly Registered User
 
Join Date: Mar 2017
Posts: 27
Thanks: 19
Thanked 0 Times in 0 Posts
QueryStumped is on a distinguished road
Re: Excel spreadsheet

Thank you. I didn't think so, but really wasn't sure. Thank you for your help.

QueryStumped is offline   Reply With Quote
Old 09-16-2018, 04:10 AM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,445
Thanks: 92
Thanked 1,834 Times in 1,704 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Excel spreadsheet

Actually you can embed an Excel spreadsheet in an Access form using an ActiveX web browser control.
See this link for one approach https://www.access-programmers.co.uk...d.php?t=297837

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
QueryStumped (09-16-2018)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Import Excel spreadsheet ernielippert General 3 12-31-2016 07:36 AM
Access sometimes opens linked Excel spreadsheet in Excel randomly? davemarco Tables 3 08-03-2015 08:09 AM
Question Excel Spreadsheet in Access DrZac General 6 10-12-2012 12:16 AM
Excel spreadsheet p595659 Reports 0 07-11-2006 03:16 AM
Linking from Excel Spreadsheet. frankbutcher Tables 0 07-17-2005 05:05 AM




All times are GMT -8. The time now is 06:13 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World