I want to import my Google contacts into a blank access table.
The structures is very different.
I exported Google contacts as a .csv (google and outlook types) and neither worked.
The exported files has 90 fields.
It did import data but it seemed to separate much of the data between the Access table fields.
I believe this is because, instead of having first name, middle initial and last name I simply have one field for this called 'Listing.'
I can't find a way to edit the exported .csv columns to match the access table
Also I'm not too keen on importing and exporting.
What is the best way to go about this?
James
The structures is very different.
I exported Google contacts as a .csv (google and outlook types) and neither worked.
The exported files has 90 fields.
It did import data but it seemed to separate much of the data between the Access table fields.
I believe this is because, instead of having first name, middle initial and last name I simply have one field for this called 'Listing.'
I can't find a way to edit the exported .csv columns to match the access table
Also I'm not too keen on importing and exporting.
What is the best way to go about this?
James