Create Excel / Word File from Access
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have the query working with 1 excel file, but it freezes when I have 2. It could be the size, or how I have the files linked. I am having access look to an excel file, which can change daily/weekly.
If you could also help clarify what I need to do to add another tab, that would be great.
The end result would to be to enter a search term, and if the word (or partial word) appears, to put the entire line in the report. For example, if I enter the word tent would give anywords like attention, discontent, intention.
Here's what I would like to do:
Instead of importing the file to Access, I would like to create a link to the Excel file. Creating the link is no problem.
Even though I name the file the same name, etc, Access make me create a new link to this new file.
Is there a way to overwrite the linked Excel file without creating a new link from Access?
I am mainframe guy and do not know too much PC software other than Word, Excel, and some PowerPoint. I was able to import Excel file into ACCESS.
Now could someone guide me how to create a TABLE from this imported file? I am determine to learn it and have bought a book about ACCESS and stillhaving difficulty following the direction.
PLEASE NOTE: I am talking about Access Services running under SharePoint; not client-side Access applications.
When a report is rendered on the web, there is an Actions button (at bottom left hand corner) which provides the options to print the report or export the report data to .pdf, Excel or Word (see first image).
Printing works and exporting to .pdf also works just fine. However when you try to export to Excel you receive the message shown in the second image and when you click ‘Yes’ Excel opens up but there is no data.
When you try to export to Word, the application (Word) opens up but there is nothing in the file (I.e., a blank Word document).
Based on a variety of web searches regarding this issue, it would appear that this was a known, unsolved problem way back at the end of 2010 (for example: [LINK]
Does anyone know how to get the exportation of report data to Excel and Word to work?
The file types are associated with the correct programs, so double clicking an Excel file for example will open it using Excel 2003.
I have an Access 97 db with a command button on the form that when clicked opens an Excel file using the FollowHyperlink code.E.g. followhyperlink “ \\servername\shared\PUBLIC\filename.xls”
I have also tried to enter the hyperlink on the format tab on the property sheet
On both occasions the file opens with Excel 97
Is there a method that I can use that will open the file in Excel 2003 All other files/shortcuts open with 2003 when double clicked
I tried to get Office 97 uninstalled except for Access 97 but we need photo editor 97 and was informed by our tech guy that they can’t remove word,excel & PowerPoint 97 and leave photo editor on because of the way our company has it packaged. It’s all done remotely and they can’t do custom installs/uninstalls.
All I want to do is open an Excel file using the 2003 version from a command button on my form.
I also cannot find it discussed on forums.
Multiple users are using individual, I am attempting to centralize the separate excel files into one access file. Even though the spreadsheetenvironment is not shared and centralized, the access file is centralized.
It is not feasible for me to run docmd.transferSpreadsheet from Access because there are too many excel files to reference. A better way is for the excel files to include an identicalmacro that references on Access file.
Secondary question: is it possible to export excel worksheets to other excel files? In this scenario I could centralize all the data into one excel file before importing that file into Access.