Errors exporting to .dbf
I am trying to use access to union two .dbf (dBASE IV) into a larger .dbf.
I've done this before, and it usually works fine. This time however, it doesn't work. When I tell it to export and then pick a file name, it says it can't find the file name I chose (it should be making it). I've tried changing the file name to C:\test.dbf which should be small enough. I've also noticed that I can do all sorts of other thing in the SQL like reorder the columns or add columns and they export fine. It's only when I try to union them that I get this error. This is what my query looks like:
UNION ALL SELECT *
Has someone seen this error before? It's driving me crazy! Is there another program that I could do this with easily that doesn't cost an arm and a leg?
BTW, I've used Access 2000, and 2003.