Variable Table Names in Create Tables/Insert Records 
Author Message
 Variable Table Names in Create Tables/Insert Records

Anybody seen any references on how to create a table from records in another
table and append records from the other table into the one that needs to be
created and/or updated.  All references I've found seem to indicate the
table name has to be 'hard coded'.  Is there a work around?  Thanks for
responding.


Fri, 21 Mar 2003 03:00:00 GMT  
 Variable Table Names in Create Tables/Insert Records
You can substitue the hard coded name for a varible in code.  Just rememebr if
the varible has to go in the middle of a string you have to break it up.

ie. "Select " & variblename & ".field from " & variblename & ";"

I hope this helped you.

Alfred

Quote:

> Anybody seen any references on how to create a table from records in another
> table and append records from the other table into the one that needs to be
> created and/or updated.  All references I've found seem to indicate the
> table name has to be 'hard coded'.  Is there a work around?  Thanks for
> responding.



Sat, 22 Mar 2003 09:33:20 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Insert SQL with variable table name problem

2. Creating Index on a table with variable as name

3. Create new table, with a variable for the name

4. Create new table, with a variable for the name

5. Creating a table via SP where the table name is a parameter

6. Eliminate records of one table based on another table record count

7. need something like foreach record in table - add record to another table

8. Copy fields from record in table A to record in table B using VBA

9. Cannot add record to Visual Foxpro table after deleting all records in table

10. INSERT INTO table name with spaces problem

11. INSERT INTO from SQL Server table into Access 97 table

12. i want to insert a print button on the table and print the table content

 

 
Powered by phpBB® Forum Software