New to access...importing database tables...Help!

[Bryan]

I would like to create a database in access from spatial data that I create
in arc view GIS so I can query my data.

I can export my datbase tables from arcview and open them in access just
fine. I always have the same data (same fields, columns, etc.) for every
project. I simply want to create a database table in Access that I could keep
adding the new records to. I have tried joining tables in access, which works
fine, but then I loose the joins everytime I exit the program and come back.
Is there a way to create a template that I could just keep populating each
time I have more data?

If the fields in my import table from ArcView are named the same as in
Access, will it automatically sort the records into the correct column even
if the columns are in a different order but named the same?

I think I eventually need to get to SQL from what I have been told....

Thanks for any help!

 

[Sharkbyte]

Bryan:

I'm not sure, but it sounds like Access is treating your arcview exports as
temporary objects, and thus dropping any relationships on closing.

You may want to try building an import specification, from your arcview
data, into an Access table. Then run your queries against those. And, since
your arcview structure doesn't change, your specification won't need to. One
caveat, however, is that the specification will expect the import file to
have the column order remain the same.

Good luck.

Sharkbyte