Select Table Fields for Export

  • Thread starter Thread starter brosner
  • Start date Start date
B

brosner

To Anyone that might help,

Hopefully, I am explaining this clearly.

I want to write a routine using VBA to select fields from
a table and export them either using delimiters, or a
fixed format. I am aware of the Transfer macro, but do
not want all fields to be export, just the ones I select
for a specific export and would change the fields [from
the same table] the next time I do the export.

Thanks, in advance, for any help.

Burt
 
Thanks Arvin.

I'm going to try that now.

Burt
-----Original Message-----
Write a query to select the fields you want from the table. Using a where
clause, you can also limit the rows. Use the query as the basis for your
export.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"(e-mail address removed)"
Click to expand...
message news:[email protected]...
To Anyone that might help,

Hopefully, I am explaining this clearly.

I want to write a routine using VBA to select fields from
a table and export them either using delimiters, or a
fixed format. I am aware of the Transfer macro, but do
not want all fields to be export, just the ones I select
for a specific export and would change the fields [from
the same table] the next time I do the export.

Thanks, in advance, for any help.

Burt
Click to expand...


.
Click to expand...
 
Back
Top