Annoying error messages

[Pietro]

Hi,

I'm copying some raws from an external tool to my database in a form
that has its default view as a datasheet.
When i copy these raws and paste them in my database,thelabels of the
raws are copied as well,so i get many error messages in my database and users
have to ok al of them to get the raws pasted.Is there a way to avoid having
all these messages?

 

[John W. Vinson]

Hi,

I'm copying some raws from an external tool to my database in a form
that has its default view as a datasheet.
When i copy these raws and paste them in my database,thelabels of the
raws are copied as well,so i get many error messages in my database and users
have to ok al of them to get the raws pasted.Is there a way to avoid having
all these messages?

What is the "external tool"? Are these coming from Text files, from some other
database, from a spreadsheet, or what?

I'd suggest one of the following suggestions:

- don't copy the header. Just don't select it.
- Write VBA code using the TransferText method; set up an import specification
that doesn't copy the header row.
- Copy the data to a temp table (with 255-byte Text fields) and run an append
query to append the non-header data to your real table

 

[pietlinden]

Hi,

    I'm copying some raws from an external tool to my database in a form
that has its default view as a datasheet.
    When i copy these raws and paste them in my database,thelabels ofthe
raws are copied as well,so i get many error messages in my database and users
have to ok al of them to get the raws pasted.Is there a way to avoid having
all these messages?

import the records instead and use an import specification?

 

[a a r o n . k e m p f]

you should be using SQL Server.. _AND_ a real ETL tool

Access shouldn't be used for copying and pasting data like this.

 

[Tony Toews [MVP]]

Please ignore the postings by Aaron Kempf. He has no value in the
newsgroups.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

It seems to me like you should not use Access to copy and paste data
like this.

Maybe you could import the data that you're looking for, using a marco
and some append queries?

 

[aaron.kempf is a robot]

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.

 

[aaron.kempf is a robot]

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.