Import from Access to Excel returns empty table.
Hello. When linking an access query to excel using method Data>Get Data> From Database> From Microsoft Access Database, the table in Excel returns the column headers but no other data. When I got to Access to check the table, everything there seems fine. Any suggestions? I'm using Access & Excel 2016.
Dynamic daily data import to MS Access
Hi, Hope that this is the right place to ask this question. I'm trying to pull data reports from a local health source on a daily basis. The only option for exporting the report file is MS Access. Data in the source have new observations (rows) that should be appended to the destination. I then export the report from Access to excel to merge data from all reports in excel (different reports for different diseases) diseases. My goal is to automate the data appending in Access and the data export to excel. I tried to save the new pulled data to Access with the same name as the previous file. This worked for me in the beginning, however, the file lost the new data after opening the file and or/exporting it to excel. In fact, it returned back to the original data list and it did not update in excel as well. Also excel updated the data after refreshing the file in the first trial but did not work afterward. I'm really stuck and any advice will be really appreciated. Than you.
Macro on Excel (16.0.15225.20204)
Hi, after the latest Office update (16.0.15225.20204), my company has problems opening excel files with Macros. I have tried in every way to enable them but I can not get over them. I have enabled macros, set the trusted path and disabled all types of file protection, but it keeps crashing the macro. The file is located on a network location. Can anyone help me? Thank youI need help figuring out why excel keeps showing an error.
I am trying to use excel on a laptop I just got today, and for my worksheet I need to import data from a Microsoft Access Database. Whenever I go to import, it brings up an error message saying my operating system is not configured for that app. I was with a support tech for the last like hour and a half. We didn't figure it out, would appreciate any insight. Please keep in mind I've only had a macbook for the past few years, so the whole pc/windows scene is very new to me. I have no clue what i'm doing.
Problems with MS Access and Excel in MSO (Version 2201 Build 16.0.14827.20028) 32-bit
The following problems are manifested in MS Access and Excel ever since MSO365 was updated. The "About Access" screen shows the following build ID. "Microsoft® Access® for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20028) 32-bit." I think I got the update around Feb 1 or 2 2022 Observed Errors: 1. MS Access table-handling automation via VBA is failing after 255 calls to Set a Recordset object. The associated error message is "error 3048cannot open any more databases." This occurs regardless of the appropriate cleanup statements which are in place to close and reset the recordsets to nothing. 2. A ghost image of MS Access persists in memory after the Access application is closed. This prevents any further database from being opened until the ghost application is removed through the task manager. 3. At times an error message is displayed as the current database is closed stating that another database is open. The message is "You attempted to open a database that is already open by another user, 'Admin'... " This seems to occur upon closing a database that failed with the error 3048 (noted above) AND when the database is set to compact on close. 4. The Find and Replace dialog form provided with the VBA IDE for both Access and Excel automatically moves to the Screen(0,0) location each time any of the action buttons are pressed (Action Buttons = Find, Find Next, Replace, Replace All). This issue does not seem to occur in the VBA IDE for my instance of Powerpoint, Outlook, and Word. This might seem to be a petty complaint but the Screen(0,0) location frequently obscures useful controls. I am currently using Windows 10. Does anyone have insight into this problem? Does upgrading to Windows 11 fix this?
Issue with KB 5002099
Hello, KB5002099 (update for Microsoft office 2016) has been causing me a lot of problems whenever I tried to connect data using source: Access into Excel. Back in January 7th, I was able to remove the update by removing KB5002099 or KB5002098 and I was able to use Excel properly It is now Jan 31st and I thought that removing the new file KB500211X would work but was unsuccessful. I can see that Microsoft has given a resolution to it to KB5002115 but that does not work. I am urgently needing some help because its a core system for our monthly function. Thanks, A
Importação de Dados do Excel para o Access
Good Morning, Thanks in advance for accepting me in this community. I created a Database in Access to collect data. Then some of this data is exported to Excel for processing (application of some calculation functions). I intended to import the results of those processing into Access. However, my Access is not updating the information. To export I have to perform the export, but there is no option to perform the import. Can you help me?Seperate Rank List
Hello All, I have a sheet that lists and ranks various data. Then I average those ranked points into a final rank which low score is the best. The data and order changes pretty consistently and the sheet and all of the overall formulas work well. However, I was wondering for (organizational purposes) could I replicate that list but it would put those main data final ranked topics in order from 1-12 Separately? Where the 1-12 list would stay the same but the topic would fall into their appropriate ranked order that week. I tried to google it but didn't have much luck. Perhaps I don't know what it is correctly called? Thank you in advance!