Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add records to table with no key

Status
Not open for further replies.

briglass

Programmer
Dec 4, 2001
179
GB
I have a table "Questions" in database data.mdb and I would like to use Visual Basic and SQL to add a record to this table.

Right now, the table's columns are:

Section, Question, Text, Type, Mask, Probe, Report

Let's say I want to create a record with the data:

"A", "B", "C", BLANK, BLANK, BLANK, "G"

How would I do this with SQL?

Thank you very much!

(This is not for a school project)

-Brian Glass
 
Actually after further inspection, the key is "Question"

However, this column is not the first one, does that matter?

Thanks

Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top