Main > Business & Finance > Database management > 4TOPS Excel Import to Access XP/03

4TOPS Excel Import Assistant is an Access add-in for importing excel into access in a controlled way. Instead of entering data one by one from a spreadsheet or another source that can be converted into a spreadsheet, the users simply need to import data, thus saving enormous amount of time and money on data entry clerks. The wizard is typically used in situations such as a new Access system where data needs to be moved from Excel to Access or for regularly importing files from outside sources or from another system. By linking Access to your ODBC compliant database (Oracle, SQL Server, etc.) you can just as easily use the wizard to transfer Excel data into that. Import multiple files or sheets in one go. If suppress messages is selected all rejected records are copied into a failed import file where the user can correct them to subsequently re-import.

Key features of 4TOPS Excel Import to Access XP/03:

• convert Microsoft Excel to Microsoft Access
•  export Microsoft Excel to Microsoft Access.
• Import multiple files or sheets in one go.
• You obtain data from different sources using mail and Microsoft Excel attachments. 
• Replace or update data in Microsoft Access from Microsoft Excel

4TOPS Excel Import to Access XP/03 screenshot: