How to query SQL Db and write results into Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: levi1998 (levi19xx_at_yahoo.com)
Date: 06/26/04 

Date: 25 Jun 2004 17:58:46 -0700

I am trying to query an SQL db and store the results of the query into
an access db. I am opening the SQL db and filling a dataset via
sqlDataAdapter.

The question is how to write this dataset into an existing table in an
access database or what other approach should I be taking to
accomplish this?

Obviously I am new at this so any help is appreciated

thx,
philip

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Data Relation question
    ... Seems to me that either you're filling the event data before you're filling ... The Sql statement you have ... > When I run the Query, ... > I would like to show all the contacts in the first datagrid. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)