Importing Google Contacts into a Blank Access Table (1 Viewer)

JamesJoey

Registered User.
Local time
Today, 08:38
Joined
Dec 6, 2010
Messages
608
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

Super Moderator
Staff member
Local time
Today, 12:38
Joined
Feb 19, 2013
Messages
16,555
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

Registered User.
Local time
Today, 08:38
Joined
Dec 6, 2010
Messages
608
Problem is, Field1 has parts of the contact name and part of the address.
It's a garbled mess.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 12:38
Joined
Feb 19, 2013
Messages
16,555
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

Super Moderator
Staff member
Local time
Today, 08:38
Joined
Jan 23, 2006
Messages
15,364
Perhaps you should show some sample records from the "garbled mess". It might give readers more info and generate some focused responses.
Good luck.
 

jdraw

Super Moderator
Staff member
Local time
Today, 08:38
Joined
Jan 23, 2006
Messages
15,364
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

Registered User.
Local time
Today, 08:38
Joined
Dec 6, 2010
Messages
608
Well, seeing that I have some personal ph0one numbers, is there another way?
 

jdraw

Super Moderator
Staff member
Local time
Today, 08:38
Joined
Jan 23, 2006
Messages
15,364
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

Registered User.
Local time
Today, 08:38
Joined
Dec 6, 2010
Messages
608
Not sure if it will help, but.
There is an address column off the right which didn't fit.

DontKNowIfItWillHelp.png
 

jdraw

Super Moderator
Staff member
Local time
Today, 08:38
Joined
Jan 23, 2006
Messages
15,364
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

Registered User.
Local time
Today, 08:38
Joined
Dec 6, 2010
Messages
608
I tried but to insert a the csv attachment but the site tells me it's an invalid file.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:38
Joined
May 7, 2009
Messages
19,175
Zip it then upload
 

Users who are viewing this thread

Top Bottom