INSERT INTO SQL - Visitor Forum - Computer Learning Zone

What sculpture is to a block of marble, education is to the human soul.

-Joseph Addison

Home Courses TechHelp Help Contact Merch Join Order Logon Forums

Home > Forums > Visitor Forum > INSERT INTO SQL by Syed Shah


	Back to Visitor Forum Comments List

INSERT INTO SQL

Syed Shah

3 years ago

Hi there. Although I'm not ur gold member but for 4 days I m stucked in a problem, seen videos, searched alot, asked chat got.... But no solution. Plz help me with this plz.
Issue: from a continues form, I want the data to be copied to a table all at once. I made a button with vba cod like
CurrentDB.Execute "INsert INTO [table1]([f1], [f2]) values ('"& me![f1] .........
As u know what this will do. But the problem is that it copy only one record, and I want all.
Plz help

	Richard Rost @Reply 3 years ago
If you INSERT VALUES then you'll only get one record. You need to INSERT with a SELECT statement.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visitor Forum.

Next Unseen