Merge tables with different fields

[vjp2.at]

I have fifteen tables I want to merge into one big table. Some of the
fields at the end of the list might be different. For example some
have x2005 y2005 x2007, others have y2005 x2007. I want to preserve
these fields, creating blanks (better yet, some other value, like 'x')
in the records that don't have them.

What is crazier is we universally use Access 2003 and these files are
DBF format which can only be read by 2007, so I have to convert them
first, which I can do when I get to borrow a 2007 machine for a few
minutes, unless someone knows a utility which can do 2007 for 2003?


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[Jerry Whittle]

Don't use "x" as it's always possible that you might actually have data that
is "x". Nulls (just leaving them empty) are better.

Create a table with all the needed fields. Then use an append query that
points to the appropriate fields that have data for each of the tables that
you want to merge.