Export Data WizardUsing the Export Data wizard you can save your table data in a text file and employ them in other applications. This wizard supports all possible record combinations, so that you will be able to open the text file in any kind of program which deals with databases. When you start the wizard, a window like this will appear:
 Export file The file path whereby you want the Export Data wizard to save your data (e.g. 'c:\\export.txt'). Click the Browse button to enter the file location from the 'Save As' dialog. Database file The database file path from which you want to export the data. Click the Browse button to enter the file location from the 'Save As' dialog. Export data from table Select a table from which you want to export data. Click the 'Next' button: 
Now we should define the format which will be used to write your data. What are delimiters, and what text qualifiers? "Last Name","First Name","Company" "Johnson","Rick","Advanced Communications" "Smith","George","HLS Designs" In the above example the data are distinguished by characters which we have called delimiters and text qualifiers. Thanks to them the program can distinguish your data and columns. In this example the delimiter role is taken by the comma (,). The quotation marks ("), in this case, is a character we shall call a text qualifier. Try to change delimiters or qualifiers and you will notice the changing of your data format at the bottom of the window. The first couple of lines of your text file will be displayed at the bottom of the screen, thus enabling you to evaluate what to select as a delimiter or a qualifier in your case. First Row Contains Field Names Select the 'First Row Contains Field Names' checkbox if you want your first text line to contain column names. See Also: E-mail Merge Extracting data from the web forms Mail Server Execute CGI Message Tags Execute Program Message Tags Scheduler |