Importing Google Contacts into a Blank Access Table

[JamesJoey]

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

 

[CJ_London]

link to the .csv file or import to a temporary table. Then use an append query to append the fields as you require. If this means splitting an import field into separate fields, you can then calculate what you require for each field as part of the append query

 

[JamesJoey]

Problem is, Field1 has parts of the contact name and part of the address.
It's a garbled mess.

 

[CJ_London]

so you'll need to use a calculation to split it into the various components required.

It will be a string so use string functions such as left, right, mid, instr etc

 

[jdraw]

Perhaps you should show some sample records from the "garbled mess". It might give readers more info and generate some focused responses.
Good luck.

 

[JamesJoey]

I credited a db with the imported data.




View attachment ImportedFromGooglContactse.accdb

 

[jdraw]

Well that's pretty garbled.
Suggest you post some records from the csv. It might also be helpful if you posted a jpg of the Google Contact list, so we can see what was garbled and possibly discern the algorithm/cause of the "garble".

 

[JamesJoey]

Well, seeing that I have some personal ph0one numbers, is there another way?

 

[jdraw]

Make a copy, modify the phone numbers--we aren't interested in the actual values.
We just need to see generic data that you received as csv from Google contacts..

 

[JamesJoey]

Not sure if it will help, but.
There is an address column off the right which didn't fit.

 

[jdraw]

No that's a picture of your data in context.
We need a sample of the data file that was exported in its base csv format.

There is a video here that shows exporting data from Gmail to csv. It talks about imorting to Outlook, but it's that csv file that seems to be key. Ignore the outlook part and see if the csv file makes sense.

 

[JamesJoey]

Here it is.

 

[jdraw]

CSV not png.

 

[JamesJoey]

I tried but to insert a the csv attachment but the site tells me it's an invalid file.

 

[arnelgp]

Zip it then upload

 

[JamesJoey]

I knew that.

View attachment Contacts.zip