|
Subject:
|
Please Help Me Dear People.
|
|
Posted By:
|
InsouciantCoquette
|
Post Date:
|
1/20/2006 4:37:46 AM
|
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.
|
|
Reply By:
|
rstelma
|
Reply Date:
|
1/21/2006 1:53:18 AM
|
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.
|
|
Reply By:
|
InsouciantCoquette
|
Reply Date:
|
1/22/2006 1:44:03 AM
|
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
Feb.mdb
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. :)
|
|
Reply By:
|
lucian
|
Reply Date:
|
1/22/2006 12:04:28 PM
|
google for it
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GEUA,GEUA:2006-03,GEUA:en&q=joining+two+access+database
|
|
Reply By:
|
InsouciantCoquette
|
Reply Date:
|
1/22/2006 8:43:56 PM
|
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 *
|
|
Reply By:
|
Imar
|
Reply Date:
|
1/23/2006 2:08:02 AM
|
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.
|
|
Reply By:
|
InsouciantCoquette
|
Reply Date:
|
1/23/2006 4:42:31 AM
|
Gee. Thanks Imar! I shall see & use the codes there. :)
* Love me for a reason; Let the reason be love *
|
|
Reply By:
|
InsouciantCoquette
|
Reply Date:
|
1/23/2006 11:09:36 PM
|
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 *
|
|
Reply By:
|
InsouciantCoquette
|
Reply Date:
|
1/24/2006 3:55:18 AM
|
Thanks for all your help people. I've solved the problem. Thanks once again. :)
* Love me for a reason; Let the reason be love *
|
|
Reply By:
|
rstelma
|
Reply Date:
|
1/24/2006 12:33:42 PM
|
So, how did you actually solve your problem?
|
|
Reply By:
|
InsouciantCoquette
|
Reply Date:
|
1/24/2006 10:06:51 PM
|
Hmm. That is a very good question rsTelma. I actually misinterpreted what was actually said by my Officer.  I'm in deep trouble because I've spent almost 6 weeks in my attachment period just thinking how to consolidate tables from multi-databases when the actualy interpretation was just to manually cntrl-c & cntrl-v the records from these tables to the designated table.  I've wasted a whole good time. But now, the real task is to copy the multi-rows of records from multi-tables of multi-databases into 1 table. Now, the real situation is here rsTelma. The records from all these tables contains multiple rows with multiple columns. And some of them has below than 1000 records while some of them has over than 60,000 records.
My Officer wants me to compile all these records into 1 table. I am just wondering, because I'm very new to this Access DB, what would happen if I wanted to display all these records in an ASP page? Wouldn't there be some functionality problem?
I'm in a panicky state where I've not yet develop any real ASP pages to show to my Officer. What should I do rsTelma? 
* Love me for a reason; Let the reason be love *
|
