Database Import Map

[puppy]

Hello, I am trying to import a database in an excel format into BCM. It keeps
asking me to Map the fields and shows in one column F1,2,3,4 etc and lets you
drag them across.

My problem is that I drag the information across but it does not go into the
correct field an I end up with surnames in first name field etc. Is there
any way the F1,2,3,4 could be changed to my column header titles so I know
which field I am mapping where?

I hope I am not the only on struggling with this, it seems such a small
issue causing me big headaches!

Thanks in advance...

 

[Luther Blissett]

Hello, I am trying to import a database in an excel format into BCM. It keeps
asking me to Map the fields and shows in one column F1,2,3,4 etc and letsyou
drag them across.

My problem is that I drag the information across but it does not go into the
correct field an I end up with surnames in first name field etc.  Is there
any way the F1,2,3,4 could be changed to my column header titles so I know
which field I am mapping where?

I hope I am not the only on struggling with this, it seems such a small
issue causing me big headaches!

Thanks in advance...

Usually the BCM import wizard display the Excel column names. You
could try exporting from Excel to CSV, and then importing the CSV into
BCM. The headers might show up then, if they're in the CSV.