Make-table issues in Access 2000.

Cegan
Cegan used Ask the Experts™
on
I have a rather large database in Access 2000 (6000 records), and would like to add columns from another table to this database.  There is a common key.  Is make table the best method?  I keep getting "invalid argument" when I use make-table, although I am giving unique names to all objects.  What else could be wrong?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Commented:
You don't need to create a new table to add columns. Simply add the columns and use an update query to set the values.  But if you do want to create a new table, have you tried a simple SELECT INTO query?

SELECT   t1.Column1, t2.OtherColumn
INTO       NameOfNewTable
FROM     TableA t1 INNER JOIN TableB t2 ON t1.CommonKey = t2.CommonKey

Author

Commented:
Yep, the SELECT INTO is a sure-fire win.  Although, I would like to combine two tables into a new table, and match the primary keys info.  That is, table one has a maplink reference with specific data, and table two has the matching data to this maplink.  Is this a WHERE feature???
Most Valuable Expert 2015

Commented:
The FROM / INNER JOIN clause in the example is used to match on the primary keys of each table. But you can certainly add a WHERE clause as well to further filter the results

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial