View Single Post
  #4  
Old July 6th, 2005, 08:04 PM
Karl Timmermans
external usenet poster
 
Posts: n/a
Default

The only reason for the CSV suggestion is that it's easier for some to deal
with then trying to figure out how to create a "named range" within Excel
(named ranges work perfectly if correctly set up for the data you want to
import) There is actually a rationale behind the use of "named ranges"
which is that it enables you to have your data anywhere within a worksheet.
However, many people just have all their data starting in row/col A1 and
aren't accustomed to "named ranges" - hence just easier to save it to CSV.

Karl

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com


"LB" wrote in message
...
Thanks - it worked!

Why the .csv? I wish Microsoft would just spell this stuff out in the
help
files.

"Karl Timmermans" wrote:

Create (or fix) a named range so that it encompasses all the data you
want
to import including the header row and you should be all set. Not sure
about
"named ranges"? Save your worksheet as a CSV file and import that file
instead.

Karl

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

"LB" wrote in message
...
I have browsed the numerous threads on this topic...

I have fields in columns, and contact records in rows. My first row
contains the field names. The data for each field has been named using
the
same names as in Row 1.

When I import, each field is imported as an individual contact. I'm
unable
to get all the fields for each record into one contact record.

Help please!