Software

Ask something
Discussion Locked

converting .vcf's into an Excel file

0 helpful
5 replies

by jcmeredith

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by oz_media

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.

by jcmeredith

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!

This discussion is closed to new replies.