Hie. I think I had posted to the wrong Forum. Ermm. But anyway, I have a very big doubt in my head that I cannot seem to decipher. Currently, I am under attachment & my project requires the person to be very well adaptable in ASP & Access Database. I am not really that good in programming but all along, I've passed all my modules. There's alot I wanted to ask but for now let me post this very big & important question to you. Let's say I have 2 database called Jan.mdb & Feb.mdb respectively. And in these 2 database I have a table called MyTable. Hence, in these two tables have exact replica of field names such as NumberID, CompanyName.. So, right now, I want to join these 2 tables into 1 major master database. Is that possible? I'm on the verge of quitting if not for my perseverence to continue in this project. Do help me please.

__________________
* Love me for a reason; Let the reason be love *

Yes you can.

Select everything from one table and insert it into the other.

Example:

INSERT INTO Jan.mdb (Column1, Column2, etc.) SELECT Column1, Column2, etc. FROM Feb.mdb

Hope this helps.

Hmm. Yes. I know that is possible only if you are in a database. But right now, I want to add these two tables called MyTable which are in both of the Jan.mdb & Feb.mdb. As in the example below:

Jan.mdb

• MyTable

Feb.mdb

• MyTable

I only know the method of joining from one table to the other table. I knew that. But, I just want to know if there is a method of joining two databases together? Thank you rsTelma for advising on the INSERT INTO method. But that is not exactly what I'm searching for. I'm really worried because my project is way past schedule. I'm afraid if I might combust in tomorrow's meeting & blast off at my Superiors for giving me such projects. Please people, I really need your opinions. Thank you once again rsTelma for enlightening me on that one. I would surely use that in my project. :)

google for it

http://www.google.com/search?sourcei...ccess+database

Thank you Lucian for that. But when I got to the link, there was only joining tables in the same or common database together. Now, I am thinking of creating manually a .mdb database & then collecting all the related MyTable from all databases & place it into that created database. And then from there I guess it would be much easier for me to join all the tables into 1 consolidated table. But, that would be no functionality in the table itself because each MyTable from each database has records of 32,000 rows with more than 20 field names. Is there any other way for me to solve this database design problem? I am using a scripting language; ASP. I welcome all opinions,questions & other possible ideas. Thanks alot.

* Love me for a reason; Let the reason be love *

Hi there,

Take a look at this article: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=143

It describes how to create an Access database in an ASP page...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Gee. Thanks Imar! I shall see & use the codes there. :)

* Love me for a reason; Let the reason be love *

I have yet thought of another solution to this. I was thinking of using COPY statement to copy a table (together with its structure & data & field names) from a .mdb to another .mdb. Is that possible? I have never do this before & I thought of asking for your opinions. Thanks.

* Love me for a reason; Let the reason be love *

Thanks for all your help people. I've solved the problem. Thanks once again. :)

* Love me for a reason; Let the reason be love *

So, how did you actually solve your problem?