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.
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 3048 cannot 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?
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.
Linking Data From Excel to Access to Sharepoint List
Hi - I retrieve data in Excel. I am trying to create a link from this data to a Sharepoint List so that the data can be shared in a separate template that includes that data as a Power Query. If I export from Excel to Sharepoint, I do not maintain a "live" refresh of the data (when the data is updated in Excel it is not reflected in Sharepoint list). I am now trying to link the data from Excel to Access and from there link it to Sharepoint. I am able to link the Excel to Access and see changes reflected; I am able to link Access to Sharepoint and see changes reflected. But I am unable to see changes reflected in Sharepoint that are made in the original Excel file. Any thoughts/suggestions/work-arounds? *Note, I am currently using Office 2013 but will be moving to 365 in the next month!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 you
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!Excel macro runs 1/12th as fast when run from Access
I have a macro that I've written to "reformat" some data in Excel (not font types and colors and such, but how the data is laid out in the spreadsheet). I found a macro that records how long it takes a macro to run, and that macro consistently runs for about 30 seconds. The problem is that the reason I'm reformatting the data is to import into Access, and I don't want my users to have to have intimate knowledge of Access or Excel to reformat the data and import it into the Access database. Thus, I've created a form with a button that allows the user to select a file from a dialog box, and then the macro runs on that file. And for some reason, when done this way, the macro takes upwards of 6 minutes. I don't know if it would be helpful to post the code of the macro here, or if there's some generic advice that will help. I just can't imagine why this increase in run-time is happening.