Re: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table

From: Mr. B (User_at_NoWhere.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 14:48:41 GMT

With Deft Fingers, "Unicorn" <unicorn@somewhere.com> wrote:

>I am not a .Not person, so I don't know if the old tried and true access
>insert query would work.

You don't know what you are missing !!!! (grin)

>INSERT INTO Table_Allowance IN "C:\MyMDB.MDB" SELECT Table_Allowance.* FROM
>Table_Allowance;

Hmmm... Interesting... I'll see if this (or something like it) will work!
Thanks!

Bruce

Relevant Pages

  • Re: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table
    ... >insert query would work. ... You don't know what you are missing ... Hmmm... ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table
    ... >insert query would work. ... You don't know what you are missing ... Hmmm... ...
    (microsoft.public.vb.database.ado)
  • Re: tempdb grows to 8G suddenly
    ... that a join predicate is missing. ... >> to someone running a query which has a join that has not been qualified ... a huge result set gets built up (in tempdb ...
    (microsoft.public.sqlserver.server)
  • Re: RM formalism supporting partial information
    ... omniscient database. ... If the user formulates a query then this will now ... If the age or occupation is missing we could ... the value-does-not-apply interpretation can always also be ...
    (comp.databases.theory)
  • Re: Adding blank lines in a report
    ... table that tells Access about the missing numbers. ... Create a query that contains both this table and the table containing ... Drag tblCount.CountID into the output grid. ... and use it as the RecordSource for your report. ...
    (microsoft.public.access.reports)