At this point you should've received a filled with ads data template from your client. Because the actual import would be conducted from an MS Access database, you would first need to Import the data from an Excel template into MS Access. This process would be the same for Ads Import and Ads Import Plus methods.

Let's assume for this example that the template you received is: 100023_import.xls and you saved it somewhere at your desktop.

Follow the steps below to convert Excel data to MS Access:

• Open Excel template and observer the data. Make sure all required fields are properly filled. Verify that there are no blank rows between the data.
• Start MS Access application. Click "New" and then "Blank Database..." on the right.
• At the prompt to create a new database type 100023_import.mdb, browse to the location where you saved "Desktop_Tools" folder and save a new database inside the "Desktop_Tools\Import" folder. This will be your desktop distribution point. Here you would be processing the converted MS Access import database.
• Click "File > Get External Data > Import..." The Import file selection box would appear. Select .xls from the "Files of type" and browse to the saved 100023_import.xls import template. Click "Import". Import Spreadsheet Wizard would begin.
• Check "First Row Contains Column Headings" and click "Next"
• "In a new Table" should already be checked (check it if not). Click "Next", "Next".
• "Let Access add primary key" should already be checked (check it if not). Click "Next".
• Within the "Import to Table" type import. Table name within the database would always have the name import. Do NOT give it any other name.
• Click "Finish". You should receive the message "Finished importing file .. "\ .... \100023_import.xls". If you received some other message about partial, invalid import, then the import failed. You need to try the import again or try to troubleshoot the template data based on an error message you have received.

Resume: At this point you should have a 100023_import.mdb database in "Desktop_Tools\Import" folder. This is a database you would be importing ads from into your classified database. If the database have at list one row where "images" field is not empty, then you would need to proceed to chapter "Processing Images" (select from menu on the left). If field "images" is empty for all rows, then there will be no image attachments to ads - proceed to chapter "Importing Ads" (select from menu on the left).