append query not appending

B

babs

I have records I am trying to append - they are not appending - i verified
that the data types are all the same. In the table I am appending into there
are a few date fields that I am not appending into but they are set to a
default value of =now().

I assumed they would just insert todays date to the newly appended records -
but I have a feeling this is why the other fields are not getting appended
into.

help!
thanks,
barb
 
D

Duane Hookom

Could you share your SQL view?
How about more information than "they are not appending"?
Have you tried to copy and paste values into the table?
 
D

Duane Hookom

Is [Visual - Billing Worksheet Report Link] a linked Excel sheet?

Did you try to copy and paste the record(s)?

You could also include the other date fields and give them the values of
Date() or Now()

INSERT INTO [Invoice Entry1] ( [Invoice Date], [Invoice Number], [Job #],
[Purchase Order #], [DateFieldB], [DateTimeFieldC] )
SELECT [Visual - Billing Worksheet Report Link].[Billing Date], [Visual -
Billing Worksheet Report Link].[Invoice #], [Visual - Billing Worksheet
Report Link].[Job #], [Visual - Billing Worksheet Report Link].PO, Date(),
Now()
FROM [Visual - Billing Worksheet Report Link];


--
Duane Hookom
Microsoft Access MVP


babs said:
Here is the SQL of the Append query - the Invoice entry1 table is a linked
table to another database- when I run it as a select query I get records to
append - When I actually try to append I get the type conversion error and
error of validation rule violations-, lock violations - so I took off all/any
validation rules , and all data types are the same - again except there are
some additional Date fields in the table I am trying to append into- that are
set as default of now() - not sure if this could be the problem??? any other
ideas???

INSERT INTO [Invoice Entry1] ( [Invoice Date], [Invoice Number], [Job #],
[Purchase Order #] )
SELECT [Visual - Billing Worksheet Report Link].[Billing Date], [Visual -
Billing Worksheet Report Link].[Invoice #], [Visual - Billing Worksheet
Report Link].[Job #], [Visual - Billing Worksheet Report Link].PO
FROM [Visual - Billing Worksheet Report Link];

example of record that shows up in if just View the appendquery(not run) in
datasheet view:
Billing Date Invoice # Job # PO
11/1/2009 45000 50608500 393101-9775




John_G via AccessMonster.com said:
Hi -

Sorry - I didn't read the message header properly (it's getting late).

One possible cause is that the append query is not selecting any data to
append. If you are using the query design grid, change the query to a select
query and run it - are any records displayed?

The are othe possible causes, but we'll start with this.

Cheers (again)

John



--
John Goddard
E-Mail: jrgoddard AT cyberus DOT ca




.
 

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

Top