Can any one help me solve this one?

J

JeanBC

Has any one come across a solution for the problem described below?

thanks for any help
JeanBC

Jack Access 2007 will not paste data correctly. When pasting data into a
table using Access 2000, all data pastes correctly. When doing the exact
same operation in Access 2007 some data is not pasted and you get no error
messages. When pasting large amounts of data, this is a big problem not
knowing if the data is making it into the database.
 
J

Jeff C

You may have issues with the data type your pasting in to a field that
specifies a different type of data.
 
K

KARL DEWEY

What is the datatype of the field you are pasting to? Post a sample of data
that is being pasted.
 
K

Klatuu

Pasting in Excel, a spreadsheet application, is a normal and natural thing to
do.
Pasting in Access, a relational database application, is like using a
screwdriver as a chisel. It doesn't work that well and you will probably
damage the screwdriver.
 
Top