Annoying error messages

  • Thread starter Thread starter Pietro
  • Start date Start date
P

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?
 
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?
Click to expand...

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
 
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?
Click to expand...

import the records instead and use an import specification?
 
you should be using SQL Server.. _AND_ a real ETL tool

Access shouldn't be used for copying and pasting data like this.
 
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?
 
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.
 
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.
 
Back
Top