Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 20th, 2006, 05:37 AM
Authorized User
 
Join Date: Jan 2006
Location: Singapore, Singapore, Singapore.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default Please Help Me Dear People.

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 *
 
Old January 21st, 2006, 02:53 AM
Friend of Wrox
Points: 2,101, Level: 18
Points: 2,101, Level: 18 Points: 2,101, Level: 18 Points: 2,101, Level: 18
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: , , .
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

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.



 
Old January 22nd, 2006, 02:44 AM
Authorized User
 
Join Date: Jan 2006
Location: Singapore, Singapore, Singapore.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default

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. :)

 
Old January 22nd, 2006, 01:04 PM
Authorized User
 
Join Date: Jun 2003
Location: Dublin, , Ireland.
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

google for it

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


 
Old January 22nd, 2006, 09:43 PM
Authorized User
 
Join Date: Jan 2006
Location: Singapore, Singapore, Singapore.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default

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 *
 
Old January 23rd, 2006, 03:08 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old January 23rd, 2006, 05:42 AM
Authorized User
 
Join Date: Jan 2006
Location: Singapore, Singapore, Singapore.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default

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

* Love me for a reason; Let the reason be love *
 
Old January 24th, 2006, 12:09 AM
Authorized User
 
Join Date: Jan 2006
Location: Singapore, Singapore, Singapore.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default

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 *
 
Old January 24th, 2006, 04:55 AM
Authorized User
 
Join Date: Jan 2006
Location: Singapore, Singapore, Singapore.
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to InsouciantCoquette Send a message via Yahoo to InsouciantCoquette
Default

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

* Love me for a reason; Let the reason be love *
 
Old January 24th, 2006, 01:33 PM
Friend of Wrox
Points: 2,101, Level: 18
Points: 2,101, Level: 18 Points: 2,101, Level: 18 Points: 2,101, Level: 18
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: , , .
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

So, how did you actually solve your problem?





Similar Threads
Thread Thread Starter Forum Replies Last Post
I need some help from you people vbpratap VB How-To 2 March 3rd, 2006 08:18 PM
Please dear god help me - nlicata SQL Server 2000 5 March 4th, 2005 12:55 AM
Planoie and People Help ! augustine General .NET 2 July 28th, 2004 09:04 AM
Dear all, I am looking a free hosting support JSP. fujinova JSP Basics 0 July 3rd, 2003 05:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.