Insertion fails

  • Thread starter Thread starter CTG
  • Start date Start date
C

CTG

I am inserting some records into my table.
I log the ones that failed to be inserted
when i manually insert the ones that do not go thru they go thru
Access.

INSERT INTO JOBTABLE
(PROFILE,PROFILE2,DESCRIPTION,SETUP,TC,TFC,TRC,CC,Laser) VALUES
('1NABVACP028','1NABVACP028','NAB Qantas Gold Visa/Amex
CONS_Replace_NoDirM Branch',66,'N','N','N','NA','Simplex')


1- does anyone know why ?
2- how do you try to feed Access a file that contains all these SQL
commands for insertions?


Cheers
 
On Wed, 24 Jun 2009 18:44:36 -0700 (PDT), CTG <[email protected]>
wrote:

How are you inserting? Show us your code, stripped to the essentials.
What error message are you receiving?

-Tom.
Microsoft Access MVP
 
Back
Top