On Mon, 25 Oct 1999 16:42:30 GMT, kghanke@my-deja.com wrote:
>1.) When I insert say two fields of data, say ten (10) records for
>both, starting at record 1. Then, I come back later to insert ten
>records into two different fields of the same table, BUT starting at
>record 1 also. SQL Toolkit wants to append (by default?) rather than
>insert the records alongside the previous insert. How do I insert
>without appending, say 2 fields of data out of 10 fields (columns) in
>the same table?
If i understand you correct:
You want to update record number 1 (to 10) with putting new data into
a field.
When you insert a new record you use the SQL command:
INSERT INTO table (field1,field2) VALUES (value1,value2);
to update a table use:
UPDATE table SET field3 = value3, field
4 = value4 WHERE condition;
This will update field3 and field4 of all records which satisfies
condition.
Without the WHERE condition you will update all records.
>2.) Is it possible to insert data into A MS Access by whole columns at
>one time, or at least whole rows????
Whole column at a time: see above.
Whole row at a time:
INSERT INTO table VALUES (value1,value2,value3......);
may work.
I have not tested the UPDATE command from LabVIEW but it is just an
ordinary SQL command.
To get some ideas of how to do things design Queries in MS-access and
take a look at the SQL code there. (There are three views of a Query:
design, table and SQL.
Also look at
http://w3.one.net/~jhoffman/sqltut.htm
Regards
Rolf