Paste append rows from table on CD

[Guest]

I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.

The first thing I did was select and Edit Copy the rows from the CD I
wanted. Then I closed the CD and opened my current database. When I went to
paste append those rows at the bottom of my current database, I received the
following messages.

The first error message says [the Value you entered isn't appropriate for
the Input Mask 99/99/00;0;# specified for this field.] I click OK.

The next message says [The value you entered isn't valid for this field.
For example, you may have entered text in anumeric field or a number that is
larger than the field siza setting permits.] I click OK

The next message says [the field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data.] I click OK about
25 times ( the number of rows to be pasted). Then it says it will put the
unpasted rows in a paste errors table.

Keep in mind these tables are identical, no changes have been made as the CD
is a backup copy. The reason I needed to use it was because I accidentally
ruined the table and had to delete the table then copy and paste a backup
table. Now only new records need to be added to the table.

 

[John Nurick]

I'd use an append query instead of copying and pasting.

I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.

The first thing I did was select and Edit Copy the rows from the CD I
wanted. Then I closed the CD and opened my current database. When I went to
paste append those rows at the bottom of my current database, I received the
following messages.

The first error message says [the Value you entered isn't appropriate for
the Input Mask 99/99/00;0;# specified for this field.] I click OK.

The next message says [The value you entered isn't valid for this field.
For example, you may have entered text in anumeric field or a number that is
larger than the field siza setting permits.] I click OK

The next message says [the field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data.] I click OK about
25 times ( the number of rows to be pasted). Then it says it will put the
unpasted rows in a paste errors table.

Keep in mind these tables are identical, no changes have been made as the CD
is a backup copy. The reason I needed to use it was because I accidentally
ruined the table and had to delete the table then copy and paste a backup
table. Now only new records need to be added to the table.

 

[Guest]

Please explain how to do the Append Query. Thanks.

I'd use an append query instead of copying and pasting.

I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.

The first thing I did was select and Edit Copy the rows from the CD I
wanted. Then I closed the CD and opened my current database. When I went to
paste append those rows at the bottom of my current database, I received the
following messages.

The first error message says [the Value you entered isn't appropriate for
the Input Mask 99/99/00;0;# specified for this field.] I click OK.

The next message says [The value you entered isn't valid for this field.
For example, you may have entered text in anumeric field or a number that is
larger than the field siza setting permits.] I click OK

The next message says [the field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data.] I click OK about
25 times ( the number of rows to be pasted). Then it says it will put the
unpasted rows in a paste errors table.

Keep in mind these tables are identical, no changes have been made as the CD
is a backup copy. The reason I needed to use it was because I accidentally
ruined the table and had to delete the table then copy and paste a backup
table. Now only new records need to be added to the table.

 

[John Nurick]

Here's one way:

1) For safety, make certain you have a current backup of your database.

2) Working in your regular database (as opposed to the CD copy), use
File|Get External Date|Link to link to the table in the CD copy.

3) Follow the instructions in Help under "Create an append query (MDB)".

Please explain how to do the Append Query. Thanks.

I'd use an append query instead of copying and pasting.

I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.

The first thing I did was select and Edit Copy the rows from the CD I
wanted. Then I closed the CD and opened my current database. When I went to
paste append those rows at the bottom of my current database, I received the
following messages.

The first error message says [the Value you entered isn't appropriate for
the Input Mask 99/99/00;0;# specified for this field.] I click OK.

The next message says [The value you entered isn't valid for this field.
For example, you may have entered text in anumeric field or a number that is
larger than the field siza setting permits.] I click OK

The next message says [the field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data.] I click OK about
25 times ( the number of rows to be pasted). Then it says it will put the
unpasted rows in a paste errors table.

Keep in mind these tables are identical, no changes have been made as the CD
is a backup copy. The reason I needed to use it was because I accidentally
ruined the table and had to delete the table then copy and paste a backup
table. Now only new records need to be added to the table.

 

[Marcin]

I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.

The first thing I did was select and Edit Copy the rows from the CD I
wanted. Then I closed the CD and opened my current database. When I went to
paste append those rows at the bottom of my current database, I received the
following messages.

The first error message says [the Value you entered isn't appropriate for
the Input Mask 99/99/00;0;# specified for this field.] I click OK.

The next message says [The value you entered isn't valid for this field.
For example, you may have entered text in anumeric field or a number that is
larger than the field siza setting permits.] I click OK

The next message says [the field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data.] I click OK about
25 times ( the number of rows to be pasted). Then it says it will put the
unpasted rows in a paste errors table.

Keep in mind these tables are identical, no changes have been made as the CD
is a backup copy. The reason I needed to use it was because I accidentally
ruined the table and had to delete the table then copy and paste a backup
table. Now only new records need to be added to the table.

===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================

 

[Guest]

Thank you for your help. I had to work with it a little bit. I tried to use
a between/and statement in the criteria row that did not work. I then tried

= 425 and <= 456 in the criteria row under Auto ID and it worked.

Also, I did not respond through email, I only used the newsgroup.

Thanks for your help.

Here's one way:

1) For safety, make certain you have a current backup of your database.

2) Working in your regular database (as opposed to the CD copy), use
File|Get External Date|Link to link to the table in the CD copy.

3) Follow the instructions in Help under "Create an append query (MDB)".

Please explain how to do the Append Query. Thanks.

I'd use an append query instead of copying and pasting.

On Thu, 25 May 2006 15:42:02 -0700, faxylady

I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.

The first thing I did was select and Edit Copy the rows from the CD I
wanted. Then I closed the CD and opened my current database. When I went to
paste append those rows at the bottom of my current database, I received the
following messages.

The first error message says [the Value you entered isn't appropriate for
the Input Mask 99/99/00;0;# specified for this field.] I click OK.

The next message says [The value you entered isn't valid for this field.
For example, you may have entered text in anumeric field or a number that is
larger than the field siza setting permits.] I click OK

The next message says [the field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data.] I click OK about
25 times ( the number of rows to be pasted). Then it says it will put the
unpasted rows in a paste errors table.

Keep in mind these tables are identical, no changes have been made as the CD
is a backup copy. The reason I needed to use it was because I accidentally
ruined the table and had to delete the table then copy and paste a backup
table. Now only new records need to be added to the table.