How to Export data to Text File/Ms Access

With Process Runner you can push data to a TXT file or Ms Access table without sending them to Ms Excel sheet. You can do the necessary settings using the following screen when you check “Ignore Excel and write ….” from Home tab.

Now with “Perform following Text Transformations” you can push data to Text file or Ms Access table it will take text as text and numeric value as numeric.

export to text

1.Text Output file: Enter the file name and path where you want to generate text file.

2.Select how the records will be written from:

a.Fixed Width (default): Here all the records will be equally wide regardless of the field contents.

b.Delimited: Here you can specify which character can delimit each field of the record. You can choose from standard delimiters to your own custom character as delimiter.

3.Overwrite output file if already exists: Select this radio button if you want to overwrite the file (default) if already exists.

4.Append to output file if already exists: Select this radio button if you want to append data to the existing (default) file.

5.Launch text file in notepad when extraction is finished: Selecting this option will open Notepad application when data extraction is over.

6.Write a separate field layout file in same location: Selecting this option you can optionally create field description file.

7.Write output fields in same sequence as Excel mapping sequence in mapper: Selecting this option will ensure that fields are written in the order of how they are mapped in Mapper. For example, if MATNR is mapped as column B and DATEUV is mapped as column A, file will have DATEUV written first and MATNR as 2nd field.

8.Add field names to same file as a header: You can have field name/field description as the first row in the output file.

**Perform following Text Transformations:

•Bring negative sign in front: By enabling this feature Process Runner will bring the negative sign in front by default.

•Change decimal sign as per current regional settings: As per the current regional settings Process Runner will change the decimal sign.

•Format SAP date fields as per regional settings: By this option when you write output to TXT file or MS Access, Process Runner will format the SAP date fields as per the regional settings.

•Format SAP time fields to HH:MM:SS: By this option when you write output to TXT file or MS Access, Process Runner will format the SAP time fields to HH:MM:SS.

•Skip and write overflow data to error file: By enabling this option Process Runner will not write overflow data (data starting with *) into TXT file and put such records into separate error log file.

export to access

1.MS Access database: Select database where you want to write data into.

2.Password: If the database is password protected, give password there by checking the password box and verify it.

3.MS Access Table Name: Enter table name in which you want to send the data into.

4.Action: You can select any one from four actions to consider while writing the data into it.

•Stop execution if table exists (default): When this is chosen, data will be only written to table if it does not exist else execution is stopped after text file is generated.

•Overwrite existing table: When this is chosen, it will create the table if it does not exists. If the table exists, all records will be erased and new records will be written.

•Create a new table (timestamp) if exists: When this is chosen, it will create the table if it does not exist. If the table exists, a new table will be created with name you have selected followed by timestamp in yyyymmdd_hhmmss) format.

•Append data to the table: When this is chosen, it will create the table if it does not exist. If the table exists, it will add records in to that table. Here it is necessary that structure of the existing table must match with the new data columns to be written.

The followings are considerations while pushing data from .txt file into MS Access table.

1.The space character can’t be used as delimiter.

2.Decimal character, date separator, time separator can’t be used as custom delimiter

3.Max. Output text file name length can’t exceed 63 characters

**Import Text Options:

•Use Schema Method: By using this method data will be imported without any import specifications .It is required that you have performed text transformation.

•Use Transfer Text Method: By using this method data will import using some import specifications selected by user. It is required that you have performed text transformation.