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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving a bunch of data 1
rgxextract() in a query to extract any one of many possibilities 2
Access Access Report Works on One Machine but not Another 3
How to limit number of Message Boxes on Validation Error? 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Copy and paste in Exel and Word 1
Auto-Increment Issue (couldn't find this one) 4
how can I double entry my data to ensure accuracy? 3

Top