Exporting query to table in external database

  • Thread starter Thread starter Toxalot
  • Start date Start date
T

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
 
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,

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
 
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
 
Back
Top