Economy Leads LLC Logo - HOWTO: Importing Canned Leads™


HOWTO:   Importing Canned Leads™

Excel 2003
Access 2003
Quattro Pro 11

Excel 2003:
Click on File and then Open
Go to the directory that you unzipped the Canned Leads™ file(s)
In Files of Type: select Text Files.
Double click on the Canned Leads™ file to import.
The Text Import Wizard appears.
Select Delimited and click Next.
Click the box that says Comma and uncheck Tab.
Set the Text qualifier to " and click Next.
At this point you can click finish.

Important note regarding Excel
Excel is limited to having a row count of 65,536. This means that if you purchase a Canned Leads™ file with more than 65,536 records you will have to break the file into multiple parts or use a macro to do it for you automatically. Quattro Pro allows up to 1,000,000 rows.

Access 2003:
Click on File, Get External Data, then Import
Go to the directory that you unzipped the Canned Leads™ file(s)
In Files of Type: select Text Files.
Double click on the Canned Leads™ file to import.
The Import Text Wizard appears.
Select Delimited and click Next.
Click the option that says Comma, click the box that says First Row Contains Field Names, set the Text Qualifier to " and click Next.
Select New Table and click Next.
Click Next again
Select No primary key and click Next
Click Finish

Quattro Pro 11:
Click on File and then Open
Go to the directory that you unzipped the Canned Leads™ file(s)
In File type: select ASCII Text.
Double click on the Canned Leads™ file to import.
The QuickColumns Expert appears.
In Parse Settings select Delimited Auto and click OK
To remove " characters click Edit then Find and Replace
In Find type " and click Replace All
Click Close

By all means these are very basic instructions on how to import a Canned Leads™ file. As with most feature rich applications there are usually several ways to accomplish a certain task. The application's help system is usually the best place to look for such a common task as importing comma-delimited text files. Vast amounts of useful information resides on the web for those who wish to manipulate data using more complicated methods.

Economy Leads LLC wishes you the greatest success!

< Home   ::   About  ::   Browse  ::   Contact  ::   Legal >

Economy Leads LLC Canned Leads™ provide an affordable alternative for your mailing lists, sales leads, telemarketing, and business directory needs.



 
Web economyleads.com
Search results will open in a new window