Error importing from .csv file into table

[Guest]

Hello,
I have created an Access db table and am trying to import data from my
OUtlook address book into the Access table.
I exported the address book via the OUtlook wizard to a CSV file. Then when
I tried to import that file into my Access table, I kept getting an error
message that field "First Name" does not exist in destination file (the
Access table I presume). First name-a text field- is the first column in each
file. I've made sure the fields and field types correspond to each other in
each table-even put the same field name but keep getting the same error. I
even deleted the first Auto-num primary key field to re-add later but no
success yet.
Any ideas what the problem could be?
Thanks, God bless
Van

 

[Tom Wickerath]

Hi Van,

I just tried several experiments, and I cannot reproduce a similar error. In each case, I used
File > Get External Data... > Import...
I didn't take the time to try creating a target table first, in Access. I chose the option to
import into a new table. You might try doing that and see if it works. If it does work, does it
include a First Name field?

Also, if you open the csv file in NotePad, you can verify whether or not there is a First Name
field. There seems to be a ton of fields available (I did not eliminate any fields in the Outlook
Export wizard screens). The first row should look something like what is shown below. Note that
the First Name field is the second field indicated.

Tom

"Title","First Name","Middle Name","Last Name","Suffix","Company","Department","Job
Title","Business Street","Business Street 2","Business Street 3","Business City","Business
State","Business Postal Code","Business Country","Home Street","Home Street 2","Home Street
3","Home City","Home State","Home Postal Code","Home Country","Other Street","Other Street
2","Other Street 3","Other City","Other State","Other Postal Code","Other Country","Assistant's
Phone","Business Fax","Business Phone","Business Phone 2","Callback","Car Phone","Company Main
Phone","Home Fax","Home Phone","Home Phone 2","ISDN","Mobile Phone","Other Fax","Other
Phone","Pager","Primary Phone","Radio Phone","TTY/TDD
Phone","Telex","Account","Anniversary","Assistant's Name","Billing
Information","Birthday","Business Address PO Box","Categories","Children","Directory
Server","E-mail Address","E-mail Type","E-mail Display Name","E-mail 2 Address","E-mail 2
Type","E-mail 2 Display Name","E-mail 3 Address","E-mail 3 Type","E-mail 3 Display
Name","Gender","Government ID Number","Hobby","Home Address PO Box","Initials","Internet Free
Busy","Keywords","Language","Location","Manager's Name","Mileage","Notes","Office
Location","Organizational ID Number","Other Address PO
Box","Priority","Private","Profession","Referred By","Sensitivity","Spouse","User 1","User
2","User 3","User 4","Web Page"

_______________________________________

Hello,
I have created an Access db table and am trying to import data from my
OUtlook address book into the Access table.
I exported the address book via the OUtlook wizard to a CSV file. Then when
I tried to import that file into my Access table, I kept getting an error
message that field "First Name" does not exist in destination file (the
Access table I presume). First name-a text field- is the first column in each
file. I've made sure the fields and field types correspond to each other in
each table-even put the same field name but keep getting the same error. I
even deleted the first Auto-num primary key field to re-add later but no
success yet.
Any ideas what the problem could be?
Thanks, God bless
Van

 

[Guest]

Hi Tom,
Thanks for your help and suggestions. I appreciate it. I'll give it a try.
God bless,
Van