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!
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.
Userform Listbox
I am having two issues with my Userform List Box. 1. When accessing the User Form in visual basics, my list box shows properly and lists the data entries. However, when I create a command button on my workbook to allow access to the User form, you are no longer able to see the list box. 2. I have the list box coded so that when an previous entry is selected from the list box, it is loaded into the userform correctly. However, when I then edit the data and save it back to the worksheet, it creates it as a new entry instead of replacing the original entry. I do not know where to begin coding on this command.