Exporting A Subset of Data From a Table w/o a Query

[redcali55]

Hi,

Is there a way to export a subset of data from a table into another Access database without using a query? Preferably some VBA code so the process can easily be repeated. The OutputTo and TransferDatabase methods don't seem to have the option of a Where condition.

The reason I don't want to use a query is because once I define the criteria (i.e. where COUNTRY = "Mozambique") I can no longer use the *. Some of the fields in the table are going to change over time and I don't want folks to have to re-create the query everytime they export (perhaps there is a way around this problem?).

Thanks!
Laura

[nico5038]

Hi Laura,

You should just use a query with parameters.
When you use in the criteria section e.g.:
[Enter country: ] underneath the Country field, Access will ask for the country when activating the query.

Idea ?

Nic;o)

[Delerna]

Yes you can do it with VBA using either DAO or ADO
Can the table you want to export the data to be linked to the database you want to export from? That would greatly simplify the code.

[redcali55]

can't link it, the database I'm exporting into needs to be sent to someone else, i.e. it needs to 'stand alone'...

Yes you can do it with VBA using either DAO or ADO
Can the table you want to export the data to be linked to the database you want to export from? That would greatly simplify the code.

[NeoPa]

That's not a good reason that it can't be linked.

As long as the filename (including folder) is the same every time.

[NeoPa]

With a link in place, you can create and execute (on the fly) your own SQL code that can be responsive to however you intend that the operator select the desired criteria.

[Delerna]

sorry, it slipped my mind that I was going to write some demo code for you.
In light of Neopa's comments.

Will you link it?
It really will be much simpler and besides if not linked, the code will still be referencing a database by name in a particular location, which is what the link does also. The link references a table in a database file at a particular location.