Union query

[coucar3456]

Group,

I have a macro set up to pull a total of 10 files from a folder on my desktop. Then I have a union query to merge all 10 tables. The union query works fine, however, some weeks I may not have 10 files, it may be 6 to 8 files. Because the union query is already staged to merge 10 files it will error out if there is not 10 files. Is there a way to keep the union query set on merging 10 tables and on error ignore.

Carter

 

[mole999]

one way, is just before the merge is initiated to use
On Error Resume Next
Its not always the best way of error trapping if you need to do specific events, but it might be your fix

 

[xenou]

I don't think that applies to SQL statements (at best the error means the query didn't work so back to square one).

 

[coucar3456]

I have my import macro set to On ERROR GO TO NEXT. If I can get the union query to do the same thing I think it will work.
I can edit the SQL by removing the union statement for the tables that didn't import and the query work just fine.

 

[xenou]

MSAccess does not have ON ERROR GOTO NEXT in the SQL language for queries.

Perhaps you post your sql and/or code to show what you are doing now.

 

[mole999]

My mistake, I see a question and don't look at the forum its in

 

[Joe4]

My mistake, I see a question and don't look at the forum its in

Tsk! Tsk! Looks like its to the time-out corner for you!

 

[mole999]

Tsk! Tsk! Looks like its to the time-out corner for you!

Well Jon seems to be out of it currently

 

[dogdays]

Do the files have specific names that do not change?
If yes you could write some VBA to edit the SQL statement.
Can you paste the SQL statement then I can give you a more conclusive answer.

Jack