Store data into Access

From: Art (Art_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 09:25:28 -0700

Hi,

I have a small table in an Access database, each record has 3 fields. I want to store 3 values into a record. I looked at the view SQL in Access and saw the following:

INSERT INTO Loaded_Tables ( TableName, Date_Added, [Rows] )
SELECT "abc" AS Expr1, Now() AS Expr2, 100 AS Expr3;

So I guess I can just use this SQL in a OleDbCommand.

Is there a better way to do this? I just found out about DataRows by reading some answers in this discussion area -- is that a good way to do it? If so, I don't know how one stores a DataRow in an Access Table.

I'd appreciate any help.

           Thanks,

           Art

Relevant Pages

  • Re: Store data into Access
    ... I'm using a stored procedure to append data to a table. ... I want to store the name of the source table, the date and the number of rows that were appended. ... I can write sql in my vb program to take care of it. ... I saw DataRows in another context, but it looked like it might be easier to store these 3 values in a DataRow and then append the DataRow to my log file. ...
    (microsoft.public.dotnet.languages.vb)
  • Store XML in a Database
    ... I need to figure out how you store a XML file down in a ... Access database, by the help of SQL. ...
    (comp.lang.java)
  • Re: Store data into Access
    ... because you are talking about Datarows. ... This method you show is probably just to store values in a database by ... > I have a small table in an Access database, ... I looked at the view SQL in Access ...
    (microsoft.public.dotnet.languages.vb)
  • Access to SQL
    ... I have some users that use an access database to store ... I was wondering if there is a way to import this access file into SQL and ...
    (microsoft.public.sqlserver.server)
  • Re: Problems with querying date field
    ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
    (microsoft.public.sqlserver.programming)