Append 2 tables with variable names

's Computer Specifications

Hi there...
Here's my problem.
I have 2 tables in an access 2000 database. The table names are
unknown...they could have any name. Through VBA how can I append one table to
the other?

's Computer Specifications

Hi,
you can run append query:

currentdb.execute "Insert into " & strTable1 & " (Field1, Field2) Select
Field1, Field2 From " & strTable2, dbfailonerror

Where strTable1 and strTable2 variables hold tables names

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"ambushsinger" <(E-Mail Removed)> wrote in message
news:9046CC5E-A9D5-4DCE-B12A-(E-Mail Removed)...
> Hi there...
> Here's my problem.
> I have 2 tables in an access 2000 database. The table names are
> unknown...they could have any name. Through VBA how can I append one table
> to
> the other?

's Computer Specifications

Thanks Alex...works perfectly!

"Alex Dybenko" wrote:

> Hi,
> you can run append query:
>
> currentdb.execute "Insert into " & strTable1 & " (Field1, Field2) Select
> Field1, Field2 From " & strTable2, dbfailonerror
>
> Where strTable1 and strTable2 variables hold tables names
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
>
> "ambushsinger" <(E-Mail Removed)> wrote in message
> news:9046CC5E-A9D5-4DCE-B12A-(E-Mail Removed)...
> > Hi there...
> > Here's my problem.
> > I have 2 tables in an access 2000 database. The table names are
> > unknown...they could have any name. Through VBA how can I append one table
> > to
> > the other?
>
> .
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Variable column names and ranges in Pivot Tables within macros.	OMER	Microsoft Excel Programming	3	21st Oct 2009 05:24 PM
Append variable to control name	Duck	Microsoft Access	4	14th Jul 2008 02:23 PM
Append [TARGETDIR] variable to system PATH variable	cnathaide@yahoo.com	Microsoft C# .NET	0	15th Aug 2007 07:54 PM
Append Query in VBA - to append VBA variable values to Access tabl	=?Utf-8?B?QWdlbnQgRGFnbmFtaXQ=?=	Microsoft Access VBA Modules	4	1st Nov 2006 04:25 PM
variable names for location of Tables ?	Isis	Microsoft Access Getting Started	2	21st Apr 2006 03:48 PM