Computing.Net > Forums > Database > Ms-access database

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Ms-access database

Reply to Message Icon

Name: Preerathi
Date: May 23, 2007 at 18:33:35 Pacific
OS: WINDOWS XP
CPU/Ram: AMD
Product: ASUS
Comment:

I am in the process of learing the database, I am wondering how to add more rows using INSERT statment. Can any one please help me out.



Sponsored Link
Ads by Google

Response Number 1
Name: Razor2.3
Date: May 26, 2007 at 20:14:17 Pacific
Reply:

INSERT INTO [table] ([column1], [column2],....)
VALUES ('value1', 'value2',...)

Note: those brackets don't denote optionally; it's how MS Access formats its SQL.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Ms-access database

Add records to .dbf database thru MS Access www.computing.net/answers/dbase/add-records-to-dbf-database-thru-ms-access/605.html

MS Access 2000 export a record www.computing.net/answers/dbase/ms-access-2000-export-a-record/193.html

MS Access for multiple computers www.computing.net/answers/dbase/ms-access-for-multiple-computers/156.html