4TOPS Excel Import Assistant is an Microsoft Access add-in for importing Microsoft Excel into Microsoft 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. The wizard is typically used in situations such as a new Microsoft Access system where data needs to be moved from Microsoft Excel to Microsoft Access or for regularly importing files from outside sources or from another system. By linking Microsoft Access to your ODBC compliant database (Oracle, SQL Server, etc.) you can just as easily use the wizard to transfer Microsoft Excel data into that. Imports 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. Now also supports Excel files saved as xml spreadsheet, xlsx, and dif format.

4TOPS Excel Import Assistant is useful in the following situations:

---

You have to convert Microsoft Excel to Microsoft Access .

You are currently working in Microsoft Excel and you want to 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