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.
I use an online software to process customer transactions. I export the transaction data to an Excel file, import the file to Access, and then use Access to create reports and receipts.
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. The problem comes in when I want to overwrite the Excel file with a new file. 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
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?
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.
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.
Is there any way that I could get the hyperlinks that are behind those words to transfer as hyperlinks instead of text?