I have a table in my database called 'mktblUpdteFromPoll'
Is VBA really the only way to make a command button that exports this to a CSV file? I have attempted to research this both here in the scripts and on the general web and have only found a couple VBA posts that I cannot seem to duplicate.
I would greatly appreciate any words of advice!
You do not have to be bothered with either VBA or Command Buttons. If you like, you can do the Export manually in only a couple of minutes. Here are the steps:
__1 Select the Table you wish to Export in the Database Window (mktblUpdteFromPoll)
__2 Select File, Export
__3 Select Save as type to Text Files (*.txt;*.csv;*.tab;*.asc)
__4 Enter a Filename
__5 In the first Export Wizard Screen, select Delimited, view the Sample export format screen and make any necessary changes by clicking the Advanced... button
__6 In the next screen, select Comma as the Delimiter.
__7 In the next screen, provide an Absolute Path to your previously defined Filename.
__8 Click Finish to Export to a *.csv Format.
-----------------------------------------------------------------------------------------------------------------
Option #2 is to create a Macro with only 2 Actions which will automate the process:
Select Object
___Object Type - Table
___Object Name - Your Table Name (mktblUpdteFromPoll)
___In Database Window - Yes
Transfer Text
___Transfer Type - Export Delimited
___Specification Name - <blank>
___Table Name - Your Table Name (mktblUpdteFromPoll)
___File Name - Absolute Path to Comma Delimited File (.txt extension)
___Has Field Names - Yes
___HTML Table - <blank>
___Code Page - <blank>
NOTE: As far as I know, there are no other Options without using VBA code.