Data Cleansing Software
Search WinPure Website
 
 

Frequently Asked Questions (FAQ) - ListCleaner Lite

 

 

Importing Files

 
 
 

My file is not listed when I choose Import from the File menu to select the file. Why not?

When I select my Access database to import, it asks me to select a table. Why?

What versions of Access are compatible with WinPure ListCleaner Lite?

When I select my Excel file to import, it asks me to select a sheet. Why?

Will it allow me to import Excel 95 spreadsheet?

I've opened a text file in but the field breaks are not shown correctly - they are all jumbled together. Why?

What versions of ACT! are compatible with WinPure ListCleaner?

What fields are imported from my ACT! database?

How do I import my contacts from Outlook into WinPure ListCleaner?

How do i fix the 'Couldn't find installable ISAM' error when I try to import?

How do I import lists from my Oracle database?

What is the maximum number of records that can imported into WinPure ListCleaner Lite?


My file is not listed when I choose Import from the File menu to select the file. Why not?

The files listed depend on the file type that you select from the 'Files of type' dropdown list. If you still can't see your file after selecting the appropriate file type, select All Files to bring your file into view.

 

When I select my Access database to import, it asks me to select a table. Why?

Access databases can contain several tables. If there is more than one, WinPure ListCleaner will ask you which table you want to import.

 

What versions of Access are compatible with WinPure ListCleaner?

WinPure ListCleaner is compatible with Access 97 & Access 2000 databases.

 

When I select my Excel file to import, it asks me to select a sheet. Why?

Excel files can contain several worksheets and ranges. If there is more than one, WinPure ListCleaner will ask you which worksheet you want to dedupe.

 

Will it allow me to import Excel 95 spreadsheet?

Yes, WinPure ListCleaner can import & export Excel 95, 97 & 2000 spreadsheets.

 

I've opened a text file in but the field breaks are not shown correctly - they are all jumbled together. Why?

WinPure ListCleaner sometimes fails to identify the text delimiter. You can choose the delimiter by selecting either comma, tab, semicolon, space and a specified character. You can even change the text qualifier, date order, and individual column types.

 

What versions of ACT! are compatible with WinPure ListCleaner?

WinPure ListCleaner is only compatible with ACT! 6

 

What fields are imported from my ACT! database?

WinPure ListCleaner will import every field that has a value, even user-defined fields.

 

How do I import my contacts from Outlook into WinPure ListCleaner?

You will firstly need to export your contacts from Outlook. In Outlook select File/Import and Export/ and choose 'Export to a File'. Next, choose either Microsoft Excel or Access, then choose the 'contacts' folder, then finally save the file.

Import this saved file directly into WinPure ListCleaner.

Once you have cleaned the files, export the file back as either an Excel 95 or Access 2000 file.

In Outlook, select File/Import and Export/ and choose 'Import from another program or file'. Next, choose either Microsoft Excel or Access, then choose the file you have just exported from WinPure ListCleaner.

How do i fix the 'Couldn't find installable ISAM' error when I try to import?

This error occurred on older versions of WinPure ListCleaner, please download the latest version and you should discover this error will not occur.

 

How do I import lists from my Oracle database?

There is no direct way of doing this, but you can export your Oracle database (and any other database) into a text file, then import that into WinPure ListCleaner.

 

What is the maximum number of records that can imported into WinPure ListCleaner Lite?

The maxiumum records you can import into ListCleaner LITE is 100,000 records. For ListCleaner PRO its 150,000 records. However, Clean & Match 2010 can handle up to 500,000 records.

 

       
 
 
Data Cleansing & Dedupe Software Specialists. Copyright (c) 2002-2010 WinPure Ltd, All Rights Reserved - Site Map