You know how when you are in a Table, you can click in between all the different rows (records) and if need be change one field on many different records quickly? A lot like a spreadsheet.
Pretty much, I'm having to intergrate an Excel spreadsheet into my database so that people can change data in just two columns the way they used to in Excel.
I tried using the ActiveX Spreadsheet control, but after fiddling around with it, looking for a help file of any kind, and surfing on the web, I couldn't find how to even link the control to my table or a SQL statement. It would appear DataSource was what I was looking for, but while it would seem to say it could pull from most anywhere, I couldn't get it to pull from a simple Table (or better yet, a Query).
The details:
I need to have a control that will function like an open Table set in a form, driven by SQL statements that draw from two existing tables, and having the option of allowing or not allowing change access to specific columns. When someone updates one of the two columns they can access, it will update yet another Table, which can later be exported and fed into another system to do something else.
If the Spreadsheet control cannot do this, it would have to be some kind of freeware ActiveX control as I have no purchasing power here.
Please, I'm on a deadline and your assistance would be greatly appriciated.
Pretty much, I'm having to intergrate an Excel spreadsheet into my database so that people can change data in just two columns the way they used to in Excel.
I tried using the ActiveX Spreadsheet control, but after fiddling around with it, looking for a help file of any kind, and surfing on the web, I couldn't find how to even link the control to my table or a SQL statement. It would appear DataSource was what I was looking for, but while it would seem to say it could pull from most anywhere, I couldn't get it to pull from a simple Table (or better yet, a Query).
The details:
I need to have a control that will function like an open Table set in a form, driven by SQL statements that draw from two existing tables, and having the option of allowing or not allowing change access to specific columns. When someone updates one of the two columns they can access, it will update yet another Table, which can later be exported and fed into another system to do something else.
If the Spreadsheet control cannot do this, it would have to be some kind of freeware ActiveX control as I have no purchasing power here.
Please, I'm on a deadline and your assistance would be greatly appriciated.