Can a Form be used to link a spreadsheet to from Excel?

cft

Registered User.
Local time
Today, 03:57
Joined
Dec 31, 2001
Messages
52
I am interested in finding out if a form can be used as the source of linked data to an Excel spreadsheet. The appearance and layout of the data appears differently than if I use a Table as the source via Cut and Paste Special Links method. The form, however, does not allow the linking option.
Thank you. cft
 
Thank you, Pat.
I have a table of refund data that needs to be available to a customer service group to respond to customer inquiries about status. What I need is the data sequenced from newest to oldest, top to bottom of the Excel spreadsheet. The Table in Access, when exported to Excel is formatted correctly, but not linked to reflect updates in Access. The Table, when Copied and Paste Special - Linked sequences the data opposite of what I need even though the Table is ordered correctly in Access. I know this is probably simple, but I cannot seem to work my way around this. Any help will be welcome. Thanks.
 

Users who are viewing this thread

Back
Top Bottom