Exporting query to table in external database

[Toxalot]

Using Access 2003 on WinXP

I want to export several queries to tables in an external database.

I found info about SELECT INTO and DoCmd.TransferDatabase and they
work great to export a subset of the data. The problem is that I
really want the exported data to maintain the relationships, indexes,
and properties, etc.

What is the best way to achieve this? Should I export the data another
way? Or use the above and create the relationships, indexes, and
properties, etc. after export? I would also have to delete the
relationships before exporting as I discovered that
DoCmd.TransferDatabase won't replace a table that is used in a
relationship.

How can I set the relationships, indexes, and properties, etc. through
VBA?

Can I count on certain default field properties? Or should I be
setting every single one?

Can I copy the relationships, indexes, and properties from the source
tables or do I have to hard code it all?

Jennifer

 

[a a r o n . k e m p f]

SQL Server allows you to easily re-create tables, indexes,
relationships, properties, etc.

Jet isn't ready for the real world.
It's too buggy for real-world use.

Do you like losing data?

I don't. I gave up on Jet 11 years ago when I saw the futility of
managing a dozen 1gb databases using Jet.

-Aaron

 

[Andrej]

Hello Toxalot,

I can do it for you.
Please reply if you want it.

Regards Andrej

 

[Access Developer]

Andrej,

You are addressing your spam to the wrong person. The one who doesn't know
how to do much of anything in this thread is Aaron the Unhelpful -- he
really needs help, and deserves all the irrelevant e-mail that you'd send.

Larry

 

[a a r o n . k e m p f]

I'm extremely helpful, if it wasn't for all the uneducated MVPs
running around, trying to get people to cling to an obsolete database