General discussion

Locked

converting .vcf's into an Excel file

By jcmeredith ·
Greetings!
I need to take about 500 v-cards (.vcf files) and convert them into something manageable like an Excel spreadsheet. From there, I will bulk load the data into an Oracle database.

So far, I have succeeded only in creating an Excel spreadsheet that is nice for say, printing mailing labels, but I need a format that's more akin to a flat-file database approach. (col A = name, etc)

Where am I doing wrong? Any ideas?

many thanks!

chris

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Oz_Media In reply to converting .vcf's into an ...

Chris I am going to start with the obvious.

A V-Card is an address book file, do you not have an address book to store them in?

Yuo can export the VoCard data into a CSV (comma separated) file which is EASILY entered into Excell via the Import CSV data command.
DATA>GET EXTERNAL DATA>Import Text file it will allow you to choose the CSV file and show you a preview of how importing will format the entries, this can also be modified from within the same window.


NOTE: If your V-CARDS are all just held in a folder the Import Text command described above will also import the V-cards into excell.

Collapse -

by jcmeredith In reply to

Sorry for my delay in closing this out! Your answer had the obvious effect of stirring me into re-visiting my options with Outlook 2K....Yes, I was (shepishly) able to get to where I wanted to go, thanks to your answer. I now have an (embarassingly easy to make) outstanding little flat-file database for bulk loading purposes. Thanks!

Collapse -

by jcmeredith In reply to converting .vcf's into an ...

This question was closed by the author

Collapse -

converting .vcf's into an Excel file

by joliywon In reply to converting .vcf's into an ...

Make use of admirable and outstanding vCard to Excel converter tool online technology market through which easily get import vCard files to Excel format without losing anything.
http://www.vcardconverter.net/vcard-converter-for-excel.html

Collapse -

convert vcard contacts to excel

by lisafrisco In reply to converting .vcf's into an ...

Hi,
Thanks for sharing info. "I was impressed with how easy the program is to use. This is the kind of program that everyone should have while convert vcard contacts to excel file .xls." http://www.vcardconverter.net/vcard-converter-for-excel.html
Thanks you for Advice Mr. Joliywon....You GREAT

Back to Software Forum
5 total posts (Page 1 of 1)  

Software Forums