Append Query

[skizzly]

Dear all,

I am trying to automate appending data from several spreadsheets and importing the data into a table. The issue I have is, how to make an append query so that if a column name on the imported spreadsheet is missing, how to automatically amend the access append query on each column that is missing, so that a default value is appended to the access table, instead of the parameter window popping up.

I was thinking of using an iif(isnull([column_name]),"No field",[column_name])

statement, but that did not work

any advice?

 

[John Big Booty]

Try the Nz() function.

 

[skizzly]

hi, thanks for the reply, tried this in the query designer:


exp1: Nz([SEN_Review_Date],"No column")

but i still get the the query parameter pop up window... any other thoughts

 

[John Big Booty]

You might be better off importing the data into a temporary table, where you can then massage the data so that it matches up with the final table you wish to append it to.