paste not working in table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

patel - 23 Jun 2004 21:46 GMT

Hi,
I have a large database that I have to populate with
material. I tried to use paste command fpr all 1000 rows ,
but it's pasting only on the first row.

Is there a way to have all rows filled by paste command?

Reply to this Message

Lynn Trapp - 23 Jun 2004 22:03 GMT

That's what append queries are for.

INSERT INTO YourTable (field1,field2,field3,...)
Select field1,field2,field3,.... From SomeTable;

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Hi,
> I have a large database that I have to populate with
> material. I tried to use paste command fpr all 1000 rows ,
> but it's pasting only on the first row.
>
> Is there a way to have all rows filled by paste command?

Reply to this Message

patel - 24 Jun 2004 16:20 GMT

I agree,
but things changed un fortunately. I have different
material on every 2000 rows. Is there a way to use append
query and populate data for every single material?

>-----Original Message-----
>That's what append queries are for.
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

Lynn Trapp - 24 Jun 2004 17:58 GMT

I'm not sure what you mean. Are you saying that you want to append new rows
and then update some of the fields in those rows?

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> I agree,
> but things changed un fortunately. I have different
[quoted text clipped - 17 lines]
> >
> >.

Reply to this Message

patel - 24 Jun 2004 20:49 GMT

What I am saying is that I have table with materials -
names and Product ID. Some of those names were missing at
the time of creating the database, that's why I left blank
spaces right next to the ID field that corresponds to the
material. We are talking about hundreds of rows for every
material. I am not sure if there is a way to fill the
names in the empty cells. There are around 6500 materials
and initially I had the names of 4500. Now I have to
populate the rest , but for every single material there is
about 10000 rows of activity(days of purchase, ect)

>-----Original Message-----
>I'm not sure what you mean. Are you saying that you want to append new rows
[quoted text clipped - 23 lines]
>
>.

Reply to this Message

Lynn Trapp - 24 Jun 2004 22:36 GMT

The way you are describing the situation makes it sound like your database
is not normalized. Can you post the structure of your tables?

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> What I am saying is that I have table with materials -
> names and Product ID. Some of those names were missing at
[quoted text clipped - 38 lines]
> >
> >.

Reply to this Message

patel - 25 Jun 2004 15:24 GMT

I received a .txt fiel containing Material ID, Name of
Material, Day of Purchase, Client, Quantity. I imported
the file in Access. The problem is that some of the
materials are discontinued and the names were deleted. I
don't know why. Everything else is in order but the naems.
The problem is that there are 4 million records, of which
a millio9n and a half are deleted(just the names) and I
have to enter the names by using the ID.Now I have to
recreate complete database and I received the list of the
deleted names that I have to populate.

Right now I am copying to Excell and pasting in Access but
it takes a lot of time.

I hope this helps

>-----Original Message-----
>The way you are describing the situation makes it sound like your database
[quoted text clipped - 44 lines]
>
>.

Reply to this Message

Lynn Trapp - 25 Jun 2004 21:03 GMT

Use an Update query to set the value of the names based on th MaterialID

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> I received a .txt fiel containing Material ID, Name of
> Material, Day of Purchase, Client, Quantity. I imported
[quoted text clipped - 75 lines]
> >
> >.

Reply to this Message

patel - 25 Jun 2004 21:50 GMT

I thought about that, but so far I am unable to produce a
valid selection.

>-----Original Message-----
>Use an Update query to set the value of the names based on th MaterialID
[quoted text clipped - 80 lines]
>
>.

Reply to this Message

Lynn Trapp - 25 Jun 2004 22:09 GMT

Without knowing you data more, I'm afraid that I can't help you. It is odd
that the number of records has grown with this thread -- 1000,2000,10000,
and finally 1,000,000

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> I thought about that, but so far I am unable to produce a
> valid selection.
[quoted text clipped - 98 lines]
> >
> >.

Reply to this Message

patel - 28 Jun 2004 21:00 GMT

Well, I have figured it

UPDATE tblMaterTable INNER JOIN SecondTable ON
tblMasterTable.ID = SecondTable.ID SET
tblMasterTable.Emp_Name = [SecondTable].
[Emp_Name];

>-----Original Message-----
>Without knowing you data more, I'm afraid that I can't help you. It is odd
[quoted text clipped - 105 lines]
>
>.

Reply to this Message