'I just want to tell you that the Excel Import Assistant is saving my bacon on my current project! This is a great tool.' Alton Brisbane, Jr. Tspec Solutions

Use 4TOPS Excel Link for Microsoft Excel mail merge.

4TOPS Import Assistant  

Import data from Microsoft® Excel® to Microsoft® Access®.

4TOPS Excel Import Assistant is an add-in for Microsoft Access 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, Microsoft® 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.

What are your importrequirements? Let us know!

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.
• The excelfiles you are working with contain more than just the desired data. You get the possibility to give up the ranges, eg. B2: K29, you want to import.
• You have to import multiple files or sheets. Do this in one go.
• You obtain data from different sources using mail and Microsoft Excel attachments. 
• You want to replace or update data in Microsoft Access from Microsoft Excel.

The wizard interface automatically matches Microsoft Excel columns with Microsoft Access table layout. The user can then make changes such as adjusting pre-matched columns, specifying fixed column value or ignore column.
After mapping Microsoft Excel columns to Microsoft Access Fields you can import Microsoft Excel into access record by record or all at once. A controlled way to  import external data. Moving row after row through your Microsoft Excel table(s) you can instantly fill in missing data or alter erroneous data before transferring them to your database.
You obtain data from different sources using mail and Microsoft Excel attachments. The add-in remembers which file to open (or location where the file can be found) and the mapping of Microsoft Excel columns onto Microsoft Access fields. After selecting the settings previously saved you can start transferring the data into the Microsoft Access table. A fast solution for multiple Microsoft Excel imports
You have already data in your Microsoft Access database but you have to add data to a new column which have been delivered to you in Microsoft Excel. E.g. adding EAN codes. Use the Find to go to the corresponding Microsoft Access record, followed by Replace.

Support For any questions or requests concerning this product or to all other 4TOPS products please contact support@4tops.com. Installation The download uses self-extracting technology for easy installation. download Microsoft Access Excel import wizard

Excel Import Assistent für Microsoft Access