I am using Quickbooks reporting tool that can export an xls or csv file. The data being exported needs to create a classroom scheduler. The data being exported is from a sales receipt via QB and contains date and time, etc.
Question is how can I get that row of data imported into access to create a calendar type schedule for those days and for the month. I need to see all the students scheduled for the each of the dates, the class description/codes, and then view an entire month to see all the class bookings?
Now the excel spreadsheet/csv file has all the columns n rows. I have looked at various calendars in excel and access, I just can't figure out how to map the data to the dates in an Access Calendar, or how to create an Excel Calendar using the dates? This needs to be a shared file, and they do not have Outlook with Exchange (which would solve my prob)
Hello dkriese, Welcome to Bytes,
In response to your question, there is no such support within Excel or Access that would be able to do what you're speaking of Out-Of-The-Box. This would require a great deal of developing. Because the Calendar control in MS Access, and the one in MS Excel DO NOT support adding data elements to them, this would mean that you would have to create a calendar-like interface, or purchase a calendar control that would support adding data elements to them.
Either way, it is either going to take you a great deal of time, since you're new to MS Access, or you can cut your time down, by either purchasing Outlook, a Calendar Control that would support Adding Items to them, or Building it yourself.
Since this forum is ment to help new people out with questions on How-To and is not ment to be a source for developement, You are more than welcome to ask any questions that you have along the way.
I hope this helps.
p.s. just do a search on your favorite search engine to locate any of the Add-In or OCX add-on for MS Access or COM Calendar controls that support what you're wanting to do.
Thanks,
Joe P.