CWatts
Well-known Member
- Joined
- Jan 22, 2010
- Messages
- 701
I'm attempting to find a way for Excel to write to an Access database and for it to work on PCs that do not have Microsoft Access installed. I have found some code here and on other sites, however, it only works with older versions of Access and we use Office 2010.
We currently have a CSV file that updates daily with data for the current month, and I've created a connection in Excel to the CSV so that the data is presented to the end user in a more usable format. Items from that file are reviewed at random and I'd like to maintain a database of those reviews.
Currently we use a SharePoint survey where the user has to enter the information in and add their comments. I'm attempting to avoid the manual data entry (and SharePoint in general) by allowing the pertinent data from the active record to be passed to Access along with user comments.
Any chance anyone would have any code laying around that would do the trick, or even an alternate suggestion for how I could handle it?
We currently have a CSV file that updates daily with data for the current month, and I've created a connection in Excel to the CSV so that the data is presented to the end user in a more usable format. Items from that file are reviewed at random and I'd like to maintain a database of those reviews.
Currently we use a SharePoint survey where the user has to enter the information in and add their comments. I'm attempting to avoid the manual data entry (and SharePoint in general) by allowing the pertinent data from the active record to be passed to Access along with user comments.
Any chance anyone would have any code laying around that would do the trick, or even an alternate suggestion for how I could handle it?
