Exporting a Query to DBF

[azimuth79]

I'm hoping this isn't a silly question, but I'm going to ask it anyways.....

I have created a fairly sizeable query combining two existing tables. I am hoping to get this query to a dbf format, so that I can link it to an existing GIS theme. When I attempt the export, I get an error stating I cannot define a field more than once.

I've found a way around this, namely by exporting to an xls file and then saving as a dbf, which works but is a hassle. Am I doing something wrong??

Thanks,

Azimuth

 

[boblarson]

Do the two tables have any of the same field names? If so, change it in the query to use aliases.