insert form

[amal1973]

I appreciate any other suggestion to create this form to insert ............
I have a SQL Server 2000 Table that contains historical and current data. I recently added 4 new columns to this table. What I want to do is to create a user form that will accepts three parameters and then sends the data to an excel sheet. The important thing now is for the user to be able to insert data in the new columns that has been fetched from the table on the excel sheet and then upload or update theses new columns in the sql table by clicking an update or an insert button. Could this be done and if their
Other way ..
Thanks

 

[SQLSister]

I'm confused, why do you need the Excel sheet at all? Why not just write an update query to add the new data to these columns for the selected record(s)?

If the new data is already on an Excel spreadsheet you can use DTS to update the data in the table.

 

[amal1973]

I agree with you, but what I still am missing to understand is how will the users update just the new columns. What I am trying to say is, I want my users to be able to update the sql table for the records they want. How and what kind of form shell I have to accomplish this task, will a form in access do the trick or in excel. I wanted excel cause my users know it better than access.
thanks

 

[aalmeida]

I would either use a VB Form or a web page to accomplish that, why not excell it is to confusing to make it work, and access is to slow AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[SQLSister]

It is also much harder to control the data entry in Excel, a user form as a web page, a VB form or an Access form can make sure data is properly input before sending it to the SQL server.

Don't worry about your users not being familar with anything but Excel. It won't take them long to learn how to do data entry on a simple form.

 

[amal1973]

is their any code out there that will help me start ..
Access or VB
thanks