0

I imported my SQL information into Access. How can I create a table in Access, then join or link it to an existing table already in Access 2010.

msiudut
  • 251
  • 1
  • 20
George
  • 1
  • Do you want to link to an already existing table within the same Access database? Are you wanting to link to another table in another database? This is a bit vague – Comrad_Durandal Feb 18 '11 at 19:49

2 Answers2

0

An easy way is to set up a UNION query. That will leave your two tables intact but join the data.

A JOIN query would merge the data into one of the existing tables.

http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-joins post has some good info about that.

msiudut
  • 251
  • 1
  • 20
0

I just use 'Access Data Projects' (ADP). This allows me to keep everything on the SQL Server side, and it allows me to write stored procedures (and bind them to forms, etc) without writing mountains of linked table / SQL passthrough code.

Aaron Kempf
  • 580
  • 2
  • 11