CREATING A AUTOMATED BUTTON

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Experts,

I wish to create a button to simplify my data export processes. I want to
export a
table using a query name myquery1 into "fixed width format text file". I
want to
learn how to create a button in a form, of which has the code behind to run
the
export function to "fixed width format text file" using "Export
Specification" named
exspec. Pls guide me ..

TQ
 
Hi GW

Look up the TransferText method in the online help.

It allows you to name the export specification you want to use, along with
the table/query you wish to export and the destination file name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXPORT TO TEXT FILES WITH FIXED WITH POSITION 3
transfertext & schema.ini 1
automation with access 3
How to Export a query to a new spreadsheet 4
Export from a form 2
Exporting a Table, Creating a csv file 1
VBA to export "Clipboard" data to text file 8
Schema.ini ignored - Export Text 1

Back
Top