LoadAccessFile

LoadAccessFile operation loads one or several tables/queries from a Microsoft Access file.

• Source - name of any file-based source
• Space - path to the file in the source (e.g. C:\Users\john\reports\)
• Table - name of Access file (e.g. end-of-month.mdb)
• Select Access tables/queries - one or more names of table of query in Access. Use the suggest list to pick from.
• Target Source - name of the target source, e.g. a relational database system
• Target Space - name of the target space
• Target Table Name Prefix - name of the result table is this prefix concatenated with the name of Access table/query specified in Select Access tables/queries. For example: access_load_.