By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Read a file from Form.

P: 23
working in Access 2003,Vba.

I have a Main Table in my database.
How can i merge or join more tables browsing files from Form.
Result should be in the Main table or in new Table.
How can i read a file from form That will merge/join with the existing table in the database.Is it possible?
For More Clarification from my side.
TableA
ID Sub1
1a XYZ
2b ABC
TableB
ID Sub2
2b MNO
3c PQR
4d GHI
TableJ...May be more tables to be merge.

Reulted table I need.
TableC
ID Sub1 Sub2
1a XYZ
2b ABC MNO
3c PQR
4d GHI
Mar 15 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
This is really two questions :
  1. How do I join tables together to produce a single output stream of records.
  2. How do I join the matching records of the resultant recordset together to show as a single output record.

Normally we don't allow multiple questions in the same thread but I imagine if we deleted this we'd get a worse mess anyway, so let's see what we can do for you :
  1. Look up UNION or UNION ALL in Access SQL Help (See Finding Jet SQL Help).
  2. For this see Combining Rows-Opposite of Union.
Mar 16 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.