Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lee90s
Starting Member
1 Post |
 Posted - 2012-04-29 : 18:02:03
|
| Hi, I'm brand new to SQL and writing queries so a lot of the stuff on these forums are still not making sense to me because I haven't learned it yet. But my question is basically is there a way to insert data into a table on microsoft access by use of an open query. What I've been reading is about different servers, and I'm not sure what they are talking about. What I have is basically a database containing information on volunteers (volunteerid, first name, last name, DOB, etc) and I would like to insert data into it by being able to prompt the user for each attribute field when they run the query. So say they want to run insert their own info, when they run the query they'd be prompted for their name, dob, and everything else. It's a very simple database because I'm just trying to learned the very basics at the moment. My professor has only showed us INSERT INTO table_name (field1, field2, field3) VALUES ('value1', 'value2', value3'); But I'd like to make it more user friendly, than having to have the person go into the code each time to insert data. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-29 : 18:59:29
|
| But my question is basically is there a way to insert data into a table on microsoft access by use of an open queryyou can do it by adding a linked server connection to access. seehttp://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/ would like to insert data into it by being able to prompt the user for each attribute field when they run the query. So say they want to run insert their own info, when they run the query they'd be prompted for their name, dob, and everything elseprompting cant be done at sql end. it needs to be implemented at front end languages like access forms,.net etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
Using and open query to insert data?