query not updatable

[isladogs]

I sympathise...as I've had similar experiences myself.



However, can I suggest you use this opportunity to put both sets of LinkedIn contacts into a single table (with no duplicates).
If necessary, you can always add a field to identify which LinkedIn source each record comes from.

Having one table means no union query is required so the issue with read only queries should be solved

[diegomarino]

that's for sure, when i build the first system i was not so competent. probably i'll make an append query to fill a local table
thanks

[isladogs]

That's exactly what I was suggesting. Good luck

[diegomarino]

Sorry for keeping asking but i found some issue.
fist of all the csv files give me problems, both using " as text qualifier than not using it. there are some guy that in a single field like "position" wrote something as "polonia, estonia, hungary" etc etc, that's a problem. The other problem is that someone uses " in some field.
is there any way to solve that problem?

[isladogs]

My approach to importing data from CSV files is as follows:
1. Link the CSV files as linked tables
2. Import the data to 'temp' buffer tables (AKA staging tables) for processing
3. Do any processing required on that data then append into the final tables
In your case that would include:
a) separating out your multiple item text into separate records
b) replacing any instances of " with a character such as ¬ before appending then replace all ¬ with " after import
4. Empty your buffer tables

Hope that helps

[diegomarino]

there's something i'm missing

i linked the csv file to my access in a linked table, the problem is that records that contains quotes are not divided by fields, and when i append to a local table the problem is still. How can i remove quotes before the import of the records field by field?

and more, the first three line are just an annotation, is there any way to start importing from the real column header?

[isladogs]

It would be better to remove the first 3 lines completely from the CSV file.
If not it will be necessary to write a routine to deal with those - I'll leave someone else to assist with that.

Form your screenshot, you seem to have chosen fixed width when linking the CSV file.
Instead link it choosing delimited with comma as the field separator and " as text qualifier

If you have any fields with text including a ", then you need to replace those with e.g. ¬ before importing into your table & then reverse that afterwards

To do so, first create a SELECT query similar to this (replacing table & field names to match your own)

SELECT Field1, Field2, Replace(Field3,"""","¬"), Replace(Field4,"""","¬"), Field5 ... FROM YourLinkedCSVTable

This assumes Field3 & Field4 have quotes in the field contents
NOTE: I deliberately used 4 sets of quotes """" above as you need to double up the inner " you want to replace

Check the outcome is what you want then convert the SELECT query into an APPEND query
...OR save the SELECT query then make an APPEND query based on that

Once the data has been imported into your table, run another query to replace all instances of ¬ with " again

[diegomarino]

sorry, i linked the csv using " as text delimiter, then ran the query:

SELECT Replace([first name],"""","¬") AS Firstname, Replace([last name],"""","¬") AS Lasttname, Connections1.[Email Address], Connections1.Company, Connections1.Position, Connections1.[Connected On;;;]FROM Connections1;

but it gives me the error you see

I Used too the query you made but the same error



maybe i'll use a routine to get rid of quotes and import correctly the csv

[isladogs]

Do you really get double quotes (") in first & last name fields?
I can understand getting single quotes/apostrophes (') in last name e.g. O'Neill and perhaps in first name as well.
If that is what you are referring to, you need to replace the single quote instead.

Hope that helps

[diegomarino]

nope unfortunely.
the problem appears with the double quotes.
i think the only solution is to use a recordset and import with a subroutine, i have to think a good procedure to do that

[isladogs]

Can you give an example

[diegomarino]

this is one of the lines that gives me problems (i changed names)

EDIT i changed the attachments, i forgot the headers

[isladogs]

But that text with the double quotes is not in the first or last name fields.
It appears to be in the Position field so you need to use the Replace function in that field

[diegomarino]

i tried with every field, but nothing. don't worry, i'll find another solution.
if you can i can pm he whole file however

[isladogs]

I don't think you can attach files to a PM. In any case, please upload a cut down version to the forum.
That way someone will look at it & hopefully solve your issue

Please provide the CSV file as well as the destination table & any code / queries used to manage the import
Nothing else should be included.
Only a few problem records need to be included in the CSV & better to change names.