how to csv database

rcnewbie

New Member
Joined
Jul 8, 2008
Messages
2
i have a database of 50,000 emails in a csv format i want to open it and export only the emails that have a 305 phone number in how do i do that.

thanks in advance
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
HI
Which cell/worksheet has phone nos in them and what is the folder/filepath where 50K mails are stored?
RAvi
 
Upvote 0
You could just import the entire file and use autofilter or for future reference, take the time to learn how to use MSQuery. It is a very handy tool that is underused.

From the workheet Menubar. Select:
  1. Menu Option - Data
  2. Menu Option - Import External Data
  3. Menu Option - New Database Query
  4. Select 'New Data Source' in the listbox
  5. Click Ok
  6. Name your Datasource what ever you wish
  7. Select a driver: Microsoft Text Driver (*.txt; *.csv) or any other driver that will work with csv files
  8. Select the directory that contains your csv file.
  9. Select your file/table
  10. Click Ok
  11. The query wizard should pop up
  12. Select all of the fields that you wish to return by double clicking each
  13. Click Next
  14. Select the column that contains your phone numbers
  15. Set the filter option such as ( begins with | 503 ) or ( begins with | (503) )
  16. Click Next
  17. Select any Sort options or skip this and...
  18. ...Click Next
  19. Select 'Return Data to MS Excel'
  20. Save your query definition here if you wish. (little button upper right)
  21. Click Finish
  22. Select your destination range...
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,995
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top