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,794
Thanks: 10
Thanked 2,105 Times in 2,060 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
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,131
Thanks: 83
Thanked 1,508 Times in 1,408 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
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.

New example databases:

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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
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.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders 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 07:04 AM.


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

Sponsored Links

How to advertise

Media Kit


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