Help Desk
Thank you for visiting our help desk. If your support question is not answered here - scroll down to the bottom of the page and submit a ticket.
How do I open the list completely?
Microsoft Excel 2003 has a limit of 65,000 rows
Excel 2007 has a limit of 1 million records.
A common challenge clients face is they can not open the files completely because they are using an old version of Microsoft Excel 2003. Files over 1 million need to be imported in Microsoft Access or broken into smaller increments using text pad. It is the clients responsibility to be aware they are purchasing a large list and that they have the software requirements to handle a large list. Microsoft offers a free 60 day trial of Microsoft Office & excel 2007.
Microsoft Office 2007
In addition Microsoft Access
Free CSV Editing software
How to split a large list with TextPad?
Click Here
How do I import text files into Microsoft Excel or Access?
Click Here
How do I download the file from files anywhere?
1. open email from Data Depot / filesanywhere
2. Click here to access the Shared File(s)
3. Enter e-signature, click I agree, click continue
4. Click big Green Download button
5. Save file
How do I unzip a file or folder?
How is the data formatted?
The standard format is Microsoft Excel .csv format. & .txt files. The Advantage XB US Business Lists are available in Microsoft Access .mdb and Excel .csv. All database can be formatted in a My SQL Dump for an additional charge.
Because of the size of the consumer data files, we have formatted them in .txt file format. which should be imported directly into an Access Database.
How do I import my list to:
If you receive a Zip file, you need to uncompress or unzip the file to use it.
1. Double-click on the Zip file.
2. It should expand automatically.
3. A file or folder with the same name (without the Zip) should appear.
4. Drag the contents of the Zip file to the desktop (or another location). When you do this, you will be copying the information from the Zip file to the computer. This will be your working copy of the data from the Zip file.
5. Close the Zip file window. You may keep the Zip file or delete it.
How do I import text files into Microsoft Excel or Access?
Click Here
How do I sort & find a particular industry, city or etc?
Click Here
NEED ADDITIONAL SUPPORT SUBMIT A TICKET.
Required fields (*)